Excel formula question.

Anonymous
2023-10-20T13:22:28+00:00

I have the following formula =MIN(D27*E27, F27*G27) which is used to find the lower of two sums. The problem I have is that I want to ignore the result if Cell F27 is a negative number as this produces an incorrect result.

My question then is how do I amend the formula to ignore the calculation if the number in F27 is negative and instead simply use the value of F27 .

In other words, use the existing formula where F27 is positive, but if negative, then simply use the value in F27 even though it is negative.

Thanks in advance

Microsoft 365 and Office | Excel | For home | Other

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

Andreas Killer 144.1K Reputation points Volunteer Moderator
2023-10-20T13:32:52+00:00

=MIN(D27*E27, IF(F27<0,F27,F27*G27))

or
=MIN(D27*E27, F27*IF(F27<0,1,G27))

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest