I need a formula to do the following:
If(c8-c9)*.04350000,75000,if(c8-c9)*.01<25000,25000,if not then (c8-c9)*.01

maybe...
=IF((C8-C9)*0.04350000,75000,IF((C8-C9)*0.01<25000,25000,(C8-C9)*0.01))



heater wrote:

I need a formula to do the following:
If(c8-c9)*.04350000,75000,if(c8-c9)*.01<25000,25000,if not then (c8-c9)*.01

--

Dave Peterson

=IF((C8-C9)*.04350000,75000,IF((C8-C9)*.01<25000,25000,(C8-C9)*.01))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"heater" wrote:

I need a formula to do the following:
If(c8-c9)*.04350000,75000,if(c8-c9)*.01<25000,25000,if not then (c8-c9)*.01

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

"heater" wrote in message
...
I need a formula to do the following:
If(c8-c9)*.04350000,75000,if(c8-c9)*.01<25000,25000,if not then
(c8-c9)*.01

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(X8750000,75000,X/100))

Dana DeLouis



On 10/12/09 1:03 PM, heater wrote:
I need a formula to do the following:
If(c8-c9)*.04350000,75000,if(c8-c9)*.01<25000,25000,if not then (c8-c9)*.01