ExcelBanter - How to solve a formula so that it returns actual answer if negati.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to solve a formula so that it returns actual answer if negati. (https://www.excelbanter.com/excel-discussion-misc-queries/2415-how-solve-formula-so-returns-actual-answer-if-negati.html)

Wayne

How to solve a formula so that it returns actual answer if negati.

I am trying to write a formula so that it displays all negative results but
defaults to zero if the answer is any positive number.

Frank Kabel

Hi
try
=MIN(your_formula,0)

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
I am trying to write a formula so that it displays all negative
results but defaults to zero if the answer is any positive number.

Jason Morin

Hi. Try:

=MIN(your_formula,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to write a formula so that it displays all
negative results but
defaults to zero if the answer is any positive number.
.

All times are GMT +1. The time now is 01:09 AM.