Results 1 to 3 of 3

Thread: help making calculation with IF

  1. #1

    help making calculation with IF



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone,

    i've been looking for a while now for an answer to this but seems like I cannot express myself good enought to find it by myself on google.

    I have a number in cell B1 and I want cell B7 to give me 1500$ if B1 is =< 10 or if B1 > 10 then (((B1-10)*50)+1500) i could not find anything yet that would permit me to do this.

    Can anyone help me out with this?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Do you mean?

    =IF(B1<=10,1500,((B1-10)*50)+1500)


  3. #3
    Thats exactly what I needed thank you very much.

Posting Permissions

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