|
|
|
|
#1
09-26-2023, 09:15 PM
|
||||
|
||||
And what value would you expect to see for
=SUM(D3-Now()) The Sum formula would be expecting multiple number values separated by commas or perhaps a range of cells. You are giving it a single value so Sum is not required. The formula would still fail if D3 doesn't have a number value (eg, it is a string). When compound formulas fail, test each constituent part to work out why it isn't working.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Rounding of dollar value
|
Formd | Mail Merge | 2 | 07-06-2022 01:21 PM |
| Custom rounding up | paulkaye | Excel | 8 | 09-03-2016 11:12 PM |
|
Excel Seems to be Rounding Twice Rather Than Once
|
melissapete24 | Excel | 5 | 08-27-2016 12:51 AM |
| Rounding to nearest 0.25 | Guloluseus | Excel | 5 | 10-27-2015 11:28 PM |
|
Standard Dev. Rounding - Excel
|
judicial85 | Excel | 1 | 08-28-2011 05:41 PM |
Windows 10 
Office 2016
Hybrid Mode