Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2022, 03:17 AM
osmononame osmononame is offline How to use rounddown function if using IF statement? Windows 10 How to use rounddown function if using IF statement? Office 2019
Novice
How to use rounddown function if using IF statement?
 
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
  #2  
Old 08-11-2022, 03:34 AM
ArviLaanemets ArviLaanemets is offline How to use rounddown function if using IF statement? Windows 8 How to use rounddown function if using IF statement? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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

Thats it! Thanks a lot!!
Reply With Quote
Reply

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
How to use rounddown function if using IF statement? WEEKNUM function not adhering to the IF statement darkoman Excel 1 06-09-2016 06:28 AM
How to use rounddown function if using IF statement? Restrict Editing function disable insert textbox function IanM_01 Word 5 11-21-2015 02:29 AM
How to use rounddown function if using IF statement? Mail Merge Function not Noticing 'True' vs. 'False' Statement danellekent Mail Merge 1 04-27-2012 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft