|
|
#3
12-17-2015, 07:52 AM
|
|||
|
|||
Yes. That works perfectly for Column V. However, for Column E I am essentially needing it to take Column U and divide it by Column E, but I can’t figure out how to do this with an “IF” statement so that I don’t get #DIV error messages where there is not input data. See attached. Thank you for helping too.
|
| Tags |
| formatting, formula help, index match |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| formula does not work properly | msnarayanan | Excel | 2 | 08-12-2015 12:40 AM |
| Dividing an Excel data report into even # of rows | zipp77ez### | Excel | 5 | 12-12-2014 09:00 PM |
| Dividing merge cell into ten equal rectangles for inputing Digit? | aligahk06 | Excel | 0 | 05-12-2010 06:56 AM |
| Dividing line at top of document? | daviddoria | Word | 0 | 10-24-2009 08:13 AM |
| Dividing by 100! | fkaramagi | Excel | 2 | 01-30-2009 02:52 PM |
Formula Help for Dividing Properly
Windows 7 32bit 
Office 2013
Threaded Mode