Formula Help

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
 
D

Dave Peterson

maybe...
=IF((C8-C9)*0.04>350000,75000,IF((C8-C9)*0.01<25000,25000,(C8-C9)*0.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.
 
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
 
Top