Nesting IF statements in Excel?

Feek · 22-11-2008, 15:38

I've worked out how to use a basic IF statement in Excel but I'm having problems getting my mind around working out multiple nested IFs.

I have a cell with a value in (Cell G13). If the value of that cell is greater than 4959.4 then I need the word 'one' displayed. That's easy.

Code:

=IF(G13>4959.4,"One","")

However, if the value of G13 is greater than 6323.2, the word 'two' should be displayed, and if it's above 8062.1 then the word 'three' displayed. Finally, if above 10279.2 then the word 'four' should be shown.

I've played around with multiple nesting using AND but I can't make it work. Can anyone help please?

22-11-2008, 15:38	#1
Feek ex SAS Join Date: Jun 2006 Location: JO01ou Posts: 10,062	Nesting IF statements in Excel? I've worked out how to use a basic IF statement in Excel but I'm having problems getting my mind around working out multiple nested IFs. I have a cell with a value in (Cell G13). If the value of that cell is greater than 4959.4 then I need the word 'one' displayed. That's easy. Code: =IF(G13>4959.4,"One","") However, if the value of G13 is greater than 6323.2, the word 'two' should be displayed, and if it's above 8062.1 then the word 'three' displayed. Finally, if above 10279.2 then the word 'four' should be shown. I've played around with multiple nesting using AND but I can't make it work. Can anyone help please? __________________