| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IFs and ORs
Tried every combination I could think of, here's what I need for for a
solution for ONE cell: If D1=2 and D3 is <14 then D5=0 , If D1=2 and D3 is 14 then D3-14*F1 OR If D1=3 and D3 is <16 then D5=0 , If D1=3 and D3 is 16 then D3-16*F1 OR If D1=4 and D3 is <17 then D5=0 , If D1=4 and D3 is 17 then D3-17*F1 How can I get this into a single formula for an answer in one cell? |
Threaded Mode
