| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula with mutltiple conditions
Hi there!
I have a problem creating a formula that would contain multiple conditions with only one possible answer. If a5=1 and b5=0 and c5=1 and d5=1 Then e5=1 If a5=1 and b5=0 and c5=1 and d5=2 Then e5=1 If a5=1 and b5=0 and c5=2 and d5=1 Then e5=1 If a5=1 and b5=0 and c5=2 and d5=2 Then e5=1 If a5=1 and b5=0 and c5=3 and d5=1 Then e5=2 If a5=1 and b5=0 and c5=3 and d5=2 Then e5=2 If a5=2 and b5=1 and c5=1 and d5=1 Then e5=2 If a5=2 and b5=1 and c5=1 and d5=2 Then e5=2 If a5=2 and b5=1 and c5=2 and d5=1 Then e5=2 If a5=2 and b5=1 and c5=2 and d5=2 Then e5=3 If a5=2 and b5=1 and c5=3 and d5=1 Then e5=3 If a5=2 and b5=1 and c5=3 and d5=2 Then e5=4 If a5=2 and b5=2 and c5=1 and d5=1 Then e5=3 If a5=2 and b5=2 and c5=1 and d5=2 Then e5=4 If a5=2 and b5=2 and c5=2 and d5=1 Then e5=4 If a5=2 and b5=2 and c5=2 and d5=2 Then e5=5 If a5=2 and b5=2 and c5=3 and d5=1 Then e5=5 If a5=2 and b5=2 and c5=3 and d5=2 Then e5=6 Is it possible? Help! Thanks in advance for your help! Greywolf -- Thanks ! Greywolf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple conditions in a formula | Excel Worksheet Functions | |||
| an excel formula for specific conditions | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Help for a formula using two conditions | Excel Worksheet Functions | |||
Threaded Mode
