The cells contain trailing digits which you are not seeing.
You could try
=(ROUND(F4,2)*(ROUND(G4,1)))
--
HTH
Bob Phillips
"millzenator"
wrote in message
...
Hello all. I am a novice Excel user, and cannot seem to locate the
source of my problem. Please help!
Here is my sheet:
C4 D4
E4 F4 G4 H4
9/22/2005 7:10 PM___10/1/2005 12:13 PM___ 8.7__52.6__6.0__317.64
Start date is entered into C4.
End date is entered into D4.
The following formula is in E4 to determine elapsed days:
=IF(D4=0,"",IF(C4=0,"",(IF(ISERROR((D4-C4)*24),"",(D4-C4)*24)/24)))
F4 contains "FLAGED HOURS" (for a body shop estimate)
G4 contains a value used for "cycle time" and is using the following
formula:
=IF(F4=0,"",F4/E4)
H4 contains a simple multiplication formula: =(F4*G4), but returns
317.64 INSTEAD of 315.6 (which is 52.6 x 6.0). I need the 315.6 result
in H4.
Would someone please tell me what I am doing wrong????
Thanks very much!
--
millzenator
------------------------------------------------------------------------
millzenator's Profile:
http://www.excelforum.com/member.php...o&userid=28042
View this thread: http://www.excelforum.com/showthread...hreadid=475490