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.

## Bookmarks