View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Lowe Don Lowe is offline
external usenet poster
 
Posts: 21
Default 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