IF Function and #VALUE Errors

scwyj · Mar 4th, 2002, 02:01 PM

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 · Mar 4th, 2002, 02:04 PM

Try this: -

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

scwyj · Mar 4th, 2002, 02:05 PM

Thanks.

sc

Ian Mac · Mar 4th, 2002, 02:06 PM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 02:01 PM	#1
scwyj New Member Join Date: Feb 2002 Location: East Sussex Posts: 33	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

Mar 4th, 2002, 02:04 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Try this: - =IF(B9="STOP",0,IF(B9>0,30,((B8/B2)*30)))

Mar 4th, 2002, 02:05 PM	#3
scwyj New Member Join Date: Feb 2002 Location: East Sussex Posts: 33	Thanks. sc