IF Function and #VALUE Errors

[scwyj]

I have the following IF Statement

=IF(B9="STOP","0"),IF(B9>0,30,((B8/B2)*30))

which is returning a #VALUE error message. I'm sure it's my over-liberal use of parentheses but I can't seem to wrap my head around this one. Can any of you resident geniuses shed some light on this for me?

Thanks,
sc

 

[Mudface]

Try this: -

=IF(B9="STOP",0,IF(B9>0,30,((B8/B2)*30)))

 

[scwyj]

Thanks.

sc

 

[Ian Mac]

On 2002-03-04 13:01, scwyj wrote:
I have the following IF Statement

=IF(B9="STOP","0"),IF(B9>0,30,((B8/B2)*30))

which is returning a #VALUE error message. I'm sure it's my over-liberal use of parentheses but I can't seem to wrap my head around this one. Can any of you resident geniuses shed some light on this for me?

Thanks,
sc

Quite right young man:

=IF(B9="STOP",0,IF(B9>0,30,(B8/B2)*30))

should do the trick, and no need for the 0 round the zero.