Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 3rd 18, 06:31 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2016
Posts: 79
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I enter a formula but the results are not displayed CAFox Excel Worksheet Functions 1 May 5th 09 04:42 AM
Displayed results in a cell WavMaster Excel Discussion (Misc queries) 3 February 7th 09 08:08 AM
IF function results not displayed in cell mrcpuhead Excel Worksheet Functions 1 July 7th 07 07:55 PM
format decimals displayed based on results widman Excel Discussion (Misc queries) 3 October 17th 06 03:35 PM
Function Formula is displayed not results iloveexcellllll Excel Worksheet Functions 0 January 11th 05 02:29 AM


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

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017