IF formula question
 

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

IF formula question
 

Hi impress,

is this the solution you were looking for?

"=ROUND(IF(V7<=1,4.1,IF(V75,19,6))*26,0)"

Please be aware that a single "V" does not work in Excel - therefore I used
V7 as a ceel reference (as you used I7 before)... ;) .

Hope this helps and best wishes,
Eric



"impress" wrote:


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