How to use rounddown function if using IF statement?

		Microsoft Office Forums > Microsoft Excel > Excel
How to use rounddown function if using IF statement?

FAQ

Thread Tools

Display Modes

08-11-2022, 03:34 AM

ArviLaanemets ArviLaanemets is offline

How to use rounddown function if using IF statement?

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

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)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:10 PM.