Nested IF Functions

[Louise]

Hi all

I am creating an IF statement which i have done many
times before, however, i need to create a nested
function, that has more than one IF statement. As I
haven't created this before, i am unsure as to where the
brackets, commas etc. go. Can anybody give me any
guidelines as to how to create a nested IF function?

Any urgent help would be appreciated.

Thank you.

Louise

 

[Govind]

Hi,

You can take this as an example

=IF(A1>90,"A",IF(A1>80,"B",IF(A1>70,"C",IF(A1>60,"D","FAIL"))))

Regards

Govind.

 

[Louise]

Excellent. thanks very much.

Louise.

-----Original Message-----
Hi,

You can take this as an example

=IF(A1>90,"A",IF(A1>80,"B",IF(A1>70,"C",IF (A1>60,"D","FAIL"))))

Regards

Govind.


.