|
|
#8
11-20-2021, 03:47 PM
|
||||
|
||||
See msg#6.
As an aside, you have many formulae with SUM in, most of which are unnecessary: =SUM(D3*$A$21)/100 can be: =D3*$A$21/100 =SUM(D3*$A$22)/100*0.95 can be: =D3*$A$22/100*0.95 =SUM(C3/K3) becomes: =C3/K3 =SUM(E3+F3) can be either: =E3+F3 or: =SUM(E3,F3) or: =SUM(E3:F3) =SUM((B3-B2)/L3) goes to: =(B3-B2)/L3 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extracting date, month & year from a text string without using date format Help | Haha88 | Excel | 5 | 08-06-2021 01:19 PM |
| Use Original Award Date or Mod Award Date For Date-Based Recurring Tasks | KBCasey27 | Project | 1 | 04-30-2021 12:22 AM |
| Change font color if date in column F is prior to today's date. | kevinbradley57 | Excel Programming | 1 | 12-05-2018 07:35 PM |
| Microsoft Project 2016 print specific date range stuck on one date | martinsalmon | Project | 1 | 10-12-2016 11:36 AM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
Windows 10 
Office 2019
Threaded Mode