Forum Discussion
Calculation error in spreadsheet
I am having a problem with fraction calculations using the sum function. For Example: Cells a1 and b1 formatted as time values Cells c1, d1, e1 in number format c1 sum(b1-a1)*24 hourly rate e...
Phil_Couzens wrote: ``I did all that and got the right result. However, when you enter a figure in d1 it shows a zero``
Do you mean: with 22 in D1 initially (as you wrote originally), the two modified formulas in C1 and E1 display 2.67 and 58.74, as intended. But after that, when you enter a different number into D1, E1 displays zero?
I cannot know why that might happen because you do not provide sufficient information. Obviously, it has nothing to do with the modifications in C1 and E1, if they worked initially.
Attach an Excel file that demonstrates the __new__ problem: E1 displaying zero.
When I re-opened the file e1 was displaying the 22 value ok.
Thanks for help
Thanks for help