Share via

Excel Formula

Anonymous
2024-04-16T18:08:10+00:00

Good Morning,

I need help with a formula

A1 = $ 300 A2 = 11.7% A3 = Return Value

Max amount I want calculated in A1 is $ 347.71 BUT if it is less than I want nothing to calculate. How do I do this?

Now the return value for A3 = $ 0.00 CORRECT ANSWER

PART 2 to this - if the value of A1 is over $ 347.71 then I want it to calculate 11.7% on the difference between $ 347.71 and the value in A1

EX = A1 = $ 447.71 (447.71 - 347.71 = $ 100) $ 100 x A2 A3 = $11.70 CORRECT ANSWER

thank you,

Carrie

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-04-16T18:11:54+00:00

=IF(A1<347.71,0,(A1-347.71)*A2)

Image

Or

=MAX(0,(A1-347.71)*A2)

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-16T18:27:31+00:00

    You are welcome:) You may also give feedback on it.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-04-16T18:21:31+00:00

    Thanks!

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more