Excel greater or less than

[Solved/Closed]
Report
Posts
23
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018
-
Posts
23
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018
-
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

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Posts
23
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018

it's work!! thank you very much!!