IFs and ANDs

[Bubba]

Hi,

i've created this formula which highlights any cell with a value of more than 0.5:

=IF(IF(ISERROR((X48-W48)/W48),"n/a",(X48-W48)/W48)>0.5,"SEE ME","OK")

it works fine but the problem is that i also want to flag up those cells that are less than 0.5... I'm guessing it needs an AND somewhere but can't suss it out - any ideas?

By the way i need to keep the ISERROR bit in the formula coz there are some blank cells knocking about...

Thanks

 

[Dave Patton]

Test 1 > 0.5 test 2<0.5

Why not just one test = 0.5

You may have to include rounding because some calculations may not yield exactly 0.5.
This message was edited by Dave Patton on 2002-09-27 07:53