Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining IF, OR, and the AND logical Functions
Hi,
I am trying to write a formula that looks at column E and determines if it has in it the words DG F or DG M. If it has either of those words, then I want the formula to go to Column E and see if there is a 1 or a 0. If a 1, then go to another worksheet and take the value from there. If a 0, replace with 9999. Below is sort of what I was thinking but it comes back with an error on the D8=0. Can anyone help? Thanks, Eden 397 IF(E8="Dg F",or(if(e8="DG M",AND(if(D8=0)=True),1,ReqPO!T7))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical Functions | Excel Discussion (Misc queries) | |||
Logical Functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions |