software

Here is the formula we have :
=IF(F7gt;=ROUND(I7*26,0),quot;freezequot;,IF(F7gt;=ROUND(I7*24 ,0),quot;warnquot;,quot;quot;))

I got another Column quot;Vquot; which has values of either 1 2 or 5. What i
need is to rewrite this formula above so that quot;=ROUND(I7*26,0)quot; the
I7 is removed and instead it checks quot;Vquot; if vlt;=1 then 4.1*26, if V is
more then 1 less then 5 then 6*26 and if V gt; 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: www.excelforum.com/member.php...oamp;userid=31515
View this thread: www.excelforum.com/showthread...hreadid=511955Hi impress,

is this the solution you were looking for?

quot;=ROUND(IF(V7lt;=1,4.1,IF(V7gt;5,19,6))*26,0)quot;

Please be aware that a single quot;Vquot; 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
quot;impressquot; wrote:

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