Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Q about: IfAnd or is it AndIf?
Dear folks,
I have used either the "andif" or is it "ifand"? function before, but for the life of me right now I can't remember the right way to make this work. This is my huge problem de jour. A B C D E 101940 1/13/2006 Friday 280 101940 1/20/2006 Friday 250 ? 101941 1/14/2006 Saturday 280 101941 1/21/2006 Saturday 280 ? I have to show the difference between D2 and D1 in cell E2 but only if A2=A1 and C2=C1. I have to show the difference between D4 and D3 in cell E4 but only if A4=A3 and C4=C3. The correct answers would be E2 = -30 and E4 = 0 Thank you very much. I really appreciate it. Michael Saffer Jacksonville, Florida |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ANDIF (i think) | Excel Worksheet Functions |