|
|
#4
06-25-2019, 12:03 AM
|
|||
|
|||
1. Into row 1 of some free column enter the formula
Code:
=6-$A1 3. Copy all cells with formula. Right-click on cell A1, and select Paste Special and then the option Values from dropdown menu; 4. Delete formulas. It's done! 
|
| Tags |
| ecxel formula, subtract from |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| vba add and subtract code | phoenixmoto | Word VBA | 6 | 11-06-2018 02:06 PM |
 Subtract value if cell contains X term
|
Jue92 | Excel | 4 | 11-01-2016 01:45 AM |
| Subtract value from one cell into another | otuatail | Excel | 3 | 02-01-2016 03:21 AM |
|
How to Subtract value in table, based on two different conditions
|
nitemath2 | Excel | 1 | 06-19-2015 01:28 AM |
| Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |
Windows 8 
Office 2016
Threaded Mode