Thread: Function making cell really "empty"
View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default
Arvi Laanemets wrote...
....
To bypass your problem, use the formula
C1=IF(A1="",0,A1)*B1

Simpler to use

=N(A1)*B1

Reply With QuoteReply With Quote