Your welcome, BTW it can be simplified to
=IF(G22="","",ROUND(H22+I22,2)*G22)
Regards,
Alan.
"Eintsein_mc2" wrote in message
oups.com...
Thanks Alan, you are right they are the results of formulas. Before I
asked for help I tried adding "ROUND" to the fomula but could not get
it to work. After looking at your formula I know why, Thanks for your
help.
Regards,
Simon
|