+ Reply to Thread
Results 1 to 6 of 6

Calculation

  1. #1
    Daywalker
    Guest

    Exclamation Calculation

    Help,

    I am trying to get a calculation to do the following.........

    =If >800

    Then * by 0.40

    =If <800 then insert '0'

    ie : if the cell contains a value of 914, it should display the value of 45.60, and if the cell contains a value less than 800, it should then display 0.

    So I have been trying to do this.............

    =if(A1>800,*0.40, if(A1<800,0))

    But it does not work ?, can anyone help with this one ?

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    I don't see how you get 45.6 from 914*0.4 but from what you ask...

    =A1*(A1>800)*0.4

  3. #3
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094
    =IF(A1>800,A1*.4,if(A1<800,0))

    This assumes that you want to multiply A1 by .4 if the condition is true. If not then the cell should be zero. Only problem is if it is = to 800, it will return FALSE. If you want it to be something different if it is = 800 then change the formula to.

    =IF(A1>800,A1*0.4,IF(A1<800,0,your third value here))

    HTH

    Steve

  4. #4
    Daywalker
    Guest
    Apologies,

    I want the cell to look, and if the value is greater than the 800 (ie: 914). then the calculation would then be 114 * 0.40 = 45.60

  5. #5
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094
    Ok so the difference between that value 914 and 800?

    =IF(A1>800,(A1-800)*.4,if(A1<800,0))


    or


    =IF(A1>800,(A1-800)*0.4,IF(A1<800,0,your third value here))

    or if it does not matter if the cell is = to or less than 800 to apply your zero then.

    =IF(A1>800,(A1-800)*.4,0)

    HTH

    Steve

  6. #6
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    =max(0,a1-800)*0.4

+ 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