If - then help.

[Guest]

this one is too complicated for my brain, so I need help... I'll do my best
to explain:

I have 4 cells (A1, A2, A3, A4)

A1 is a total dollar amount of a small section of a group of amounts

A2 is a grand total dollar amount of the entire sheet before any percentage
discounts are applied.

A3 is a percentage of discount that will be applied to A2.

A4 is a calculation resulting in 2% of A2 (A2*.02)

A5 is the total after all discounts are applied.

So here's the rub:
I need to subtract A4 from A5 only if A1 is greater than or equal to A4.

 

[Rick Rothstein \(MVP - VB\)]

this one is too complicated for my brain, so I need help... I'll do my

best
to explain:

I have 4 cells (A1, A2, A3, A4)

A1 is a total dollar amount of a small section of a group of amounts

A2 is a grand total dollar amount of the entire sheet before any
percentage
discounts are applied.

A3 is a percentage of discount that will be applied to A2.

A4 is a calculation resulting in 2% of A2 (A2*.02)

A5 is the total after all discounts are applied.

So here's the rub:
I need to subtract A4 from A5 only if A1 is greater than or equal to A4.

You seem to be describing this...

=IF(A1>=A4,A5-A4,"")

Am I missing something?

Rick

 

[Pete_UK]

Reading between the lines, the OP probably meant this:

=IF(A1>=A4,A5-A4,A5)

which, of course, could also be written:

=A5-(A1>=A4)*A4

Hope this helps.

Pete

 

[Guest]

I probably didn't complete the discription. A5 need to be a total of
everything, so it is 'A5=(A2-(A2*A3)) this is without consideration of the
equation I'm trying to address, so my problem lies with putting the above
equation into one that accomplishes what you responded with. Would it be
something like this:
'A5=(A2-(A2*A3)-(A4IF(A1>=A4))

 

[Rick Rothstein \(MVP - VB\)]

Is this what you are looking for?

=A2-(A2*A3)-IF(A1>=A4,A4,0)

Rick

 

[Guest]

=A2-(A2*A3)-(A1>=A4)*A4

=A2*(1-A3)-(A1>=A4)*A4

I probably didn't complete the discription. A5 need to be a total of
everything, so it is 'A5=(A2-(A2*A3)) this is without consideration of the
equation I'm trying to address, so my problem lies with putting the above
equation into one that accomplishes what you responded with. Would it be
something like this:
'A5=(A2-(A2*A3)-(A4IF(A1>=A4))

 

[Guest]

Close.. I had to do this to make it work =A2-(A2*A3)-IF(A1>=A4,(A1-A4),0)

thanks for all your help!!!!