#1
|
|||
|
|||
How to use rounddown function if using IF statement?
Hi,
I am trying to create a new spreadsheet with a formula: =IF(E12>650000,48350+(0.14*(E12-650000)),IF(E12>300000,(0.1*(E12-300000)+5850),IF(E12>245000,(0.02*(E12-245000)+2100),IF(E12>155000,0.01*(E12-155000),0)))) I am pretty sure there will be a simpler formula to get the sum I need but with my skills this is all I can manage - to be honest it works well but I need it to round down to the nearest whole number / no fractions if that makes sense? So if the output is 2002.75 I need the cell to show 2002.00. Is that possible and if so what would I need to amend? |
#2
|
|||
|
|||
What about
Code:
=ROUNDDOWN(IF(E12>650000,48350+(0.14*(E12-650000)),IF(E12>300000,(0.1*(E12-300000)+5850),IF(E12>245000,(0.02*(E12-245000)+2100),IF(E12>155000,0.01*(E12-155000),0)))) ,0) |
#3
|
|||
|
|||
Thats it! Thanks a lot!!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF statement in a CONCANTENATE function | hunterisagrump | Excel | 3 | 03-08-2020 02:58 PM |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
WEEKNUM function not adhering to the IF statement | darkoman | Excel | 1 | 06-09-2016 06:28 AM |
Restrict Editing function disable insert textbox function | IanM_01 | Word | 5 | 11-21-2015 02:29 AM |
Mail Merge Function not Noticing 'True' vs. 'False' Statement | danellekent | Mail Merge | 1 | 04-27-2012 02:19 AM |