Formula Help

[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

 

[Dave Peterson]

maybe...
=IF((C8-C9)*0.04>350000,75000,IF((C8-C9)*0.01<25000,25000,(C8-C9)*0.01))

 

[Luke M]

=IF((C8-C9)*.04>350000,75000,IF((C8-C9)*.01<25000,25000,(C8-C9)*.01))

 

[David Biddulph]

The place to find the syntax of the IF function (and every other Excel
function except for DATEDIF) is in Excel help.

 

[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