View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default How to stop cells with no data entered, from showing the formu

Hi Mike H,
Many many thanks, works perfectly.
Regards,
Dave

"Mike H" wrote:

Try these three

=IF(C2="","",D2/(C2*0.2199692483))
=IF(D2="","",C2/(D2*1.609344)*100)
=IF(C2="","",I2/C2)

Mike
"Dave" wrote:

Hi and thanks for replying.
I am new to this and would appreciate your help.
The 3 formula's I am using a
=D2/(C2*0.2199692483)
=C2/(D2*1.609344)*100
=I2/C2
I don't want to appear cheeky but, could you please let me know what they
need to be?
Thanks again,
Dave