#1
|
|||
|
|||
Populate title based on cell comparison
In the attached spreadsheet, I would like to do the following: if the total in column F is less than column E, populate the title from column C under the "Needed" category in column I. Then calculate and place the Delta for that item in column J. Thank you for your help. |
#2
|
|||
|
|||
I2 =IF(F2<E2,C2,"")
J2 =IF(I2<>"",F2-E2,"") Copy down to end of data |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
is sit possible to auto populate a cell based on dates | wheddingsjr | Excel | 6 | 11-27-2017 11:21 AM |
Auto populate cell based on certain situations | YW3 | Excel | 10 | 05-26-2017 02:02 AM |
Populate a table based on choices from drop down menu | Xaand | Word VBA | 0 | 02-25-2014 11:08 AM |
how to populate textbox based on combobox selection in word | IvanGeorgiev | Word | 1 | 02-21-2013 07:32 PM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |