Using IF and ROUND in same calculation

[BongoBill]

Hi all, I'm using Excel 2002.

I'm creating a spreadsheet to calculate materials with the following columns Cost/10% of Cost/Customer Cost/Qty/Total cost.

I understand that whilst showing rounded to 2 decimal places excel stores more than this in the cell. which then throws out the Total cost by a few pence.

My research leads me to believe I need to use the ROUND function but I'm unsure which cell to use it or how.

I attach an example to show my problem. You will note cell E7 shows the incorrect answer.

Any help much appreciated

[NBVC]

New formula in C3:

=IF(COUNT(A3:B3)<2,"",ROUND(A3+B3,2))

copied down

[jj72uk]

Yes, you can use round and if

Like..

=ROUND(IF(COUNT(A5)<1,"",A5*(10/100)),2)

See sheet