View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Novice Novice is offline
external usenet poster
 
Posts: 52
Default problems with if function

I would like c1 to display b1/a1 if a1 and b1 not empty but would like c1 to
remain empty if nothing in a1 and b1

the following works but only if there is a value in a1 and b1.
=IF(AND(A1="", B1=""),"", B1/A1)

if a1 and b1 empty c1 shows hashkey value!

what am I doing wrong