H
heater
I need a formula to do the following:
If(c8-c9)*.04>350000,75000,if(c8-c9)*.01<25000,25000,if not then (c8-c9)*.01
If(c8-c9)*.04>350000,75000,if(c8-c9)*.01<25000,25000,if not then (c8-c9)*.01
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
maybe...
=IF((C8-C9)*0.04>350000,75000,IF((C8-C9)*0.01<25000,25000,(C8-C9)*0.01))
=IF((C8-C9)*0.04>350000,75000,IF((C8-C9)*0.01<25000,25000,(C8-C9)*0.01))
L
Luke M
=IF((C8-C9)*.04>350000,75000,IF((C8-C9)*.01<25000,25000,(C8-C9)*.01))
D
David Biddulph
The place to find the syntax of the IF function (and every other Excel
function except for DATEDIF) is in Excel help.
function except for DATEDIF) is in Excel help.
D
Dana DeLouis
Hi. Just to be different. If 'X represents C8-C9, are you sure there
is a discontinuous jump when this value is 8,750,000 ?
=IF(X<2500000,25000,IF(X>8750000,75000,X/100))
Dana DeLouis
is a discontinuous jump when this value is 8,750,000 ?
=IF(X<2500000,25000,IF(X>8750000,75000,X/100))
Dana DeLouis