| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Subtraction question
Subtracting cells C2 thru I2
Example: If C2 had 3436, D2 had 3395, E2 had 3376, then I need the answer in cell J2 to be 60 EVEN IF THE CELLS F2 THRU I2 ARE BLANK. This formula works fine if I have numbers in ALL cells (C2:I2) "=MAX(C2:H2)-I2" but when there are blank cell it doesn't count right. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtraction Question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
| Formula Question.....PLEASE PLEASE help! | Excel Discussion (Misc queries) | |||
Threaded Mode
