+ Reply to Thread
Results 1 to 12 of 12

can you do this?

  1. #1
    Registered User
    Join Date
    02-17-2005
    Posts
    19

    can you do this?

    hello, i don't know much about excel but i'm guessing that it should be able to do this.
    Iv'e got a column full of numbers(F), formatted so that they are currency. I'm wanting to make a column next to it that will have some formula that goes

    IF F2 <= 400 THEN display F2+£30
    IF F2 > 400 THEN display F2+£50

    it's just a delivery charge that needs to be added on.

    Thanks if anyone can help me

    Alistair

  2. #2
    Registered User
    Join Date
    02-17-2005
    Posts
    7
    Try this formula:

    =if(f2<=400,f2+30,f2+50)

  3. #3
    Registered User
    Join Date
    02-17-2005
    Posts
    19
    thanks very much for that, it works well but there are empty fields that are coming up as £30. Is there a way of adding a statement

    If empty THEN do nothing

  4. #4
    Registered User
    Join Date
    02-01-2005
    Posts
    13

    Nested If

    Try it this way, this is called a nested if statment (more thank one IF statment in one formula)

    =IF(A2=0,"",IF(A2<=400,A2+30,IF(A2>=500,A2+50)))

    Just change the A2's to F2's.

    Hope this helps.

    Mark

  5. #5
    Registered User
    Join Date
    02-17-2005
    Posts
    19
    that works too, cheers

    but when it tried to calculate a cell that contained "Net Buying EX VAT" it threw out £70?! any ideas why?

  6. #6
    Registered User
    Join Date
    02-01-2005
    Posts
    13
    Not without knowing more about what you are trying to do.

  7. #7
    Registered User
    Join Date
    02-17-2005
    Posts
    19
    sorry about that last one we had the wrong cells numbers put in, working sweet now thanks v much

  8. #8
    Registered User
    Join Date
    02-01-2005
    Posts
    13
    Glad to have helped!

  9. #9
    Registered User
    Join Date
    02-17-2005
    Posts
    19
    just out of interest, would you be able to tell us how to add a percentage of say 20% to the number we have there

  10. #10
    Registered User
    Join Date
    02-17-2005
    Posts
    7
    I have updated it:

    =IF(G22=0,"",IF(G22<=700,G22+30,G22+50))

    Let me know if this works...

  11. #11
    Registered User
    Join Date
    02-17-2005
    Posts
    19
    we are wanting to add a percenatge of 20% to cell G22 before we add the delivery charge
    can you help us out with that one

    again thanks a lot!

  12. #12
    Registered User
    Join Date
    02-17-2005
    Posts
    7
    to add 20%, use:

    =IF(G22=0,"",IF(G22<=400,G22*1.2+30,G22*1.2+50))

+ 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