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

 

[chowell45014]

I'm an Excel rookie in comparison to a lot of folks here, but I think one of these will work, depending on which answer you want when the conditions aren't met...

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

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

 

[Aladin Akyurek]

Maybe...

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

 

[SamS]

Aladin, this was the one that I wanted, thanks again

 

[SamS]

chowell45014, Aladin thanks for your responses, unfortunately found that while the formulae worked while F8 was not inerror and G8 was in error but when both cells were in error then none of the formulae worked.

I have modified the formula like this as I want two conditions met.

1st condition is where F8 is not in error and G* is in error
2nd condition is where both F8 & G7 are in error

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

All attempts have resulted in a #N/A on the second condition.

Frustrated as I can apply each one individually and get it to work but not together. Unfortunately can't use Colo's download at work due to restrictions by our IT dept.

 

[Scott Huish]

F8 & G7? What happened to F8 and G8?

To clarify:
If F8 is ERROR and G8 is Error then E8+F11
If F8 is ERROR and G8 is Not Error then E9+F11
Any other combination is #N/A

Is this correct?

What kind of errors are you expecting?

 

[SamS]

Hot Pepper

forgive me - a little dyslexic today - should be F8 & G8

your explanation is what I am after - not expecting to get errors but am getting #n/a when applying any of the formula yet breaking the formula up and applying individually not getting any errors but getting the expected figure.

thanks

 

[Scott Huish]

How does Aladin's answer not work?

What I meant by what kind of errors you're expecting, you're using ISERROR so you must be expecting some kind of error in the cells.

 

[SamS]

again I wasn't succint - it returned the correct value if F8 was not in error but not if it was in error

I have to logoff but will check back later

 

[Scott Huish]

But isn't this what you want?

Book3
	E	F	G	H	I
8	11	#N/A	#N/A		15
9	16
10
11		4
Sheet1

Book3
	E	F	G	H	I
8	11	0	#N/A		#N/A
9	16
10
11		4
Sheet1

Book3
	E	F	G	H	I
8	11	#N/A	0		20
9	16
10
11		4
Sheet1

Book3
	E	F	G	H	I
8	11	0	0		#N/A
9	16
10
11		4
Sheet1