How to use rounddown function if using IF statement?

osmononame · #1 08-11-2022, 03:17 AM

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?

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