Here is the formula we have :
=IF(F7=ROUND(I7*26,0),"freeze",IF(F7=ROUND(I7*24 ,0),"warn",""))
I got another Column "V" which has values of either 1 2 or 5. What i
need is to rewrite this formula above so that "=ROUND(I7*26,0)" the
I7 is removed and instead it checks "V" if v<=1 then 4.1*26, if V is
more then 1 less then 5 then 6*26 and if V 5 19*26. I hope this
makes sense. I only need to edit the fist half of the original formula
above.
--
impress
------------------------------------------------------------------------
impress's Profile:
http://www.excelforum.com/member.php...o&userid=31515
View this thread:
http://www.excelforum.com/showthread...hreadid=511955