Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding something to a complicated formula
Hey peeps! I have a formula that turns the cell red if the number of received items is less than the number ordered, and only if the scheduled date they were to come in is past today's date. I would like to add in the formula the ability to recognize in the ordered and recieved column if I needed to order more at a later date, or if I received the total items at different times...like 11+3 in the ordered column, meaning I ordered 11, realized I needed more and ordered 3 more. Can I make a formula to recognize this additional requirement? Here is the original formula I have in the cells: =AND(E3<D3,TODAY()G3). Thanks. -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=494894 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Complicated formula | Excel Worksheet Functions | |||
Formula for adding several worksheet totals | Excel Discussion (Misc queries) | |||
Complicated Formula | Excel Discussion (Misc queries) | |||
Formula help : adding | New Users to Excel |