Thread: How to use rounddown function if using IF statement?
View Single Post
 
Old 08-11-2022, 03:17 AM
osmononame osmononame is offline Windows 10 Office 2019
Novice
  
Join Date: Aug 2022
Posts: 2
osmononame is on a distinguished road
Default 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?
Reply With Quote