Microsoft Office Forums - View Single Post - Percentage calculations based on if over or under

Thread: Percentage calculations based on if over or under

View Single Post

Old

01-04-2018, 11:43 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

=(c5>0)*(c5<=5000)*c5*0.1+(c5>5000)*((c5-5000)*0.25+5000*0.1)

Reply With Quote