Excel greater or less than

Solved/Closed
Winndixie Posts 23 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018 - Mar 10, 2014 at 10:48 PM
Winndixie Posts 23 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018 - Mar 10, 2014 at 11:28 PM
Hi all,

I'm having a problem that with multi counting with less than, eg.

case 1:
A1 = 1000 (total revenue)
B1 = 3% (rebate)
C1 = 2000 (free copy)

case 2:
A1 = 8000 (total revenue)
B1 = 3% (rebate)
C1 = 2000 (free copy)

I need a formula that when A1 - B1 the net revenue less than C1 the result become 0, but case 2 when A1 - B1 the revenue greater than C1 eg. A1 - B1 = 7760, then 7760 - C1

I wrote a formula like below but failure to work...
=SUM((A1-(A1*B1)), "<=" &C1,0,D1-C1) ---- (get the net revenue)

thank you!!

1 reply

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Mar 10, 2014 at 11:23 PM
Winndixie, Good evening.

Try to use:
=IF((A1-(A1*B1))<=C1,0,(A1-(A1*B1))-C1)

Please, tell us if it worked for you.
I hope it helps
0
Winndixie Posts 23 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018
Mar 10, 2014 at 11:28 PM
it's work!! thank you very much!!
0