IF formula question

[impress]

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
need is to rewrite this formula above so that "=ROUND(I7*26,0)" th
I7 is removed and instead it checks "V" if v<=1 then 4.1*26, if V i
more then 1 less then 5 then 6*26 and if V > 5 19*26. I hope thi
makes sense. I only need to edit the fist half of the original formul
above

 

[Guest]

Hi impress,

is this the solution you were looking for?

"=ROUND(IF(V7<=1,4.1,IF(V7>5,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