ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Displayed results (https://www.excelbanter.com/excel-programming/454121-displayed-results.html)

GARYWC

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 ?


All times are GMT +1. The time now is 01:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com