nested IF

[SamS]

Having trouble putting together a nested IF statement, it all depends on whether the cell G8 is in error or not, probably a better way to do it. Here are the 2 formula I need nested:

=IF(AND(ISERROR(F8),ISERROR(G8)),E8+F11,#N/A)

=IF(AND(ISERROR(F8),NOT(ISERROR(G8))),E9+F11)

thnx

 

[Aladin Akyurek]

Aladin, don't know why but this formula just doesn't want to work for me

=IF(ISERROR(F8),IF(ISERROR(G8),E8,E9)+F11,NA())

will try the variation hotpepper has suggested (got a football game on I want to watch) tomorrow.

HP - I change my profile hit submit and keep getting server cannot be found after about 1 minute.

It shouldn't be that difficult to post the values that you have in F8, G8, E8, E9, and F11 in a situation where the formula "doesn't want to work" for you. You don't need an exhibit at all for this.

 

[SamS]

Aladin, I think I have stuffed up. Looking closely the formula in F9 should have been.
=IF(ISERROR(E8),IF(ISERROR(F8),E8,E9)+F11,NA())

Need to get some glasses, I think. Have managed to update my profile now and will try and get the html maker to work.