View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dennis dennis is offline
external usenet poster
 
Posts: 202
Default Trying to get a blank cell presented if B26=0

IF B26=0, how do I present a blank cell in another place, or put an amount if
not true. I have used =IF(B26=0,0,Sheet1!E2) , but I get a $0.00 figure
which I do not want. Even I if I used a blank cell for the true portion, I
get then same $0.00 figure.
I get the right amount for false. I am preparing an excel program for a
small plowing business.