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
|