+ Reply to Thread
Results 1 to 2 of 2

IF formula question:edit the fist half of the original formula

  1. #1
    Registered User
    Join Date
    02-13-2006
    Posts
    1

    IF formula question:edit the fist half of the original formula

    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.

  2. #2
    Eric_MUC
    Guest

    re: IF formula question:edit the fist half of the original formula

    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



    "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
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1