If the hourly rate is in Cell A1 and the Hours are in Cell B1 then use this
formula.
=Round(A1*B1,2)


"adelaide" wrote:

hi we have a simple formula to work out employees pay (hourly rate x hours
worked = gross amount) however currently exel is not recognising a 6 as a 6
in the final total eg 520.16 +520.10 should = 1040.26 however it is showing
1040.15
also if .11cents shows it rounds it to 0 and 520.16=520.16 the total shows
1040.11 can someone please help i have not set it up to round up or down