Sample Answer

[Marie Randazzo]

Hi, this looks like a great site. I believe I have a simple question that I just can't find the answer to.

After I type a formula into a cell for example an =If(f6>0,D6-F6,D6) the cell shows $0.00, which is the sample answer but I don't want this to show. I just want to have the formula in the cell with the cell showing nothing until I enter the currency in the other cells.

Thanks,
Marie

 

[JPM]

Try this one =If(f6="","",If(f6>0,D6-F6,D6)) that way it only populates the cell if f6 is not blank. Or you could use =If(OR(f6="",D6=""),"",If(f6>0,D6-F6,D6)) which would leave it blank until D6 and F6 are not blank.

JPM

 

[Scott Huish]

Give this a try:

=IF((D6="")+(F6=""),"",D6-(F6*(F6>0)))

 

[Aladin Akyurek]

Hi, this looks like a great site. I believe I have a simple question that I just can't find the answer to.

After I type a formula into a cell for example an =If(f6>0,D6-F6,D6) the cell shows $0.00, which is the sample answer but I don't want this to show. I just want to have the formula in the cell with the cell showing nothing until I enter the currency in the other cells.

Thanks,
Marie

Care to elaborate by way of an example?...

D6 empty, F6 empty ===> ?

D6 houses 8, F6 empty ===> ?

D6 houses 8, F6 5 ===> ?

D6 empty, F6 5 ===> ?