Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displayed results
d15 contains: =B15/((G15-E15)*24) (the displayed result is: 4.34347826086957 -- the format is 'Number' with 2 decimal places
b15 contains: 6.66 (the displayed result is: 6.66 -- the format is 'Number' with 2 decimal places g15 contains: 14:02:00 (the displayed result is: 2:02 PM -- the format is 'Custom' with 'Type' h:mm AM/PM e15 contains: 12:30:00 (the displayed result is: 12:30 PM -- the format is 'Custom' with 'Type' h:mm AM/PM c9 contains: =INDIRECT("D15") (the displayed result is: 4.34347826086957 -- the format is 'Number' with 2 decimal places How do I get c9 to display: 4.34 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I enter a formula but the results are not displayed | Excel Worksheet Functions | |||
Displayed results in a cell | Excel Discussion (Misc queries) | |||
IF function results not displayed in cell | Excel Worksheet Functions | |||
format decimals displayed based on results | Excel Discussion (Misc queries) | |||
Function Formula is displayed not results | Excel Worksheet Functions |