ExcelBanter - I need a "0" when cell is empty

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - I need a "0" when cell is empty (https://www.excelbanter.com/excel-programming/410986-i-need-0-when-cell-empty.html)

Don Lowe

I need a "0" when cell is empty

The following formula works good except for when there is no value in the
cell. What can I do to the formula to be "0" when the C22 has no value in the
cell?

=MIN(10,C22)

C22 Formula Result
10 (It should be zero)
1 1
5 5
10 10
15 10

Rick Rothstein \(MVP - VB\)[_1939_]

I need a "0" when cell is empty

Try this...

=IF(C22="",0,MIN(10,C22))

Rick

"Don Lowe" wrote in message
...
The following formula works good except for when there is no value in the
cell. What can I do to the formula to be "0" when the C22 has no value in
the
cell?

=MIN(10,C22)

C22 Formula Result
10 (It should be zero)
1 1
5 5
10 10
15 10

merjet

I need a "0" when cell is empty

=IF(C22="",0,MIN(10,C22))

Hth,
Merjet

All times are GMT +1. The time now is 08:02 PM.