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!!
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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
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