ExcelBanter - FORMULA

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

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

- - FORMULA (https://www.excelbanter.com/excel-discussion-misc-queries/147786-formula.html)

LESLIE

FORMULA

HI, I'M TRYING TO DO THE FOLLOWING:
=IF((MIN I9:I32)500,0,-2.5)
ITS IF THE MIN BETWEEN I9:I32 IS GREATER THAN 500, THEN 0 ,IF NOT THEN -2.5
WHAT AM I DOING WRONG?
LES

Dave Peterson

FORMULA

Misplacing ()'s:

=IF(MIN(I9:I32)500,0,-2.5)

(maybe???)

leslie wrote:

HI, I'M TRYING TO DO THE FOLLOWING:
=IF((MIN I9:I32)500,0,-2.5)
ITS IF THE MIN BETWEEN I9:I32 IS GREATER THAN 500, THEN 0 ,IF NOT THEN -2.5
WHAT AM I DOING WRONG?
LES

--

Dave Peterson

All times are GMT +1. The time now is 04:37 PM.