Please help with formula.

[Rick88]

I am trying to set up a formula so that when there is a division between two cells, the result is entered into another cell and if no entry is entered into the cells, then the other is left blank.
Example;

if D34 is divided by B34, enter the result into C34 as a currency value with two decimal places.
if no numbers are entered into D34 and B34 then C34 should be blank.

I know this is probably child's play for most of you on here but I am still a "youth" when it comes to excel, I am learning on my own and I appreciate your help.
Thanks,
Rick

 

[mvptomlinson]

Hi Rick,

Format cell C34 as Currency with two decimal places. Then enter this formula into C34:

=IF(OR(B34="",D34=""),"",D34/B34)

 

[Rick88]

I tried that formula but C34 is still coming up blank even with data entered into D34 and B 34. Any suggestions?
Thanks,

I forgot to mention I am using 2003.

 

[pedro-egoli]

It works fine with me and I am using 2003.

Perhaps you could post the actual formula you have in C34.

Pedro

 

[mvptomlinson]

Make sure:

1. Calculation is set to Automatic, or manually re-calc your sheet (F9)
2. You don't have conditional formatting on that cell (e.g. font set to white based on some condition)
3. You don't have any macros running that are clearing those cells

etc..

 

[Rick88]

Thanks, I got that to working but now I am looking for a better way to auto fill these cells as there are many to fill with another formula but I will start a new thread for that.
Thank you guys very much.
Rick