Add more conditions to IF formula

[wiredgecko]

I have the following equation:

=IF(AND(S19="yes",$V$5>0),VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0))

I'm having trouble adding to this equation: if S19="no", return a value of 0.

Hoping explained my self and someone can help.

Thanks

Alex

 

[mrshl9898]

Like this?

=IF(S19="no",0,IF(AND(S19="yes",$V$5>0),VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0)))

 

[Michael M]

try

=IF(S19="no",0,IF(AND(S19="yes",$V$5>0),VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0)))

If you only have yes / no in S19 you could also use

=IF(S19="no",0,IF($V$5>0,VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0)))

 

[wiredgecko]

Like this?

=IF(S19="no",0,IF(AND(S19="yes",$V$5>0),VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0)))

Thanks, worked great

 

[Michael M]

Glad to help...