Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with OR statement
Hi. Currently I have the following Excel formula, which returns 2 if the
statement is TRUE and returns 0 if the statement is FALSE. =if(Or(O4=1,(And(O4=7,O3<7))),2,0) Is it possible to format this statement to return a 1 if the OR statement is TRUE, but return a 2 if the AND statement is TRUE? Thanks! |
#2
|
|||
|
|||
=if(O4=1,1,IF(And(O4=7,O3<7))),2,0))
perhaps? -- HTH RP (remove nothere from the email address if mailing direct) "MrMike" wrote in message ... Hi. Currently I have the following Excel formula, which returns 2 if the statement is TRUE and returns 0 if the statement is FALSE. =if(Or(O4=1,(And(O4=7,O3<7))),2,0) Is it possible to format this statement to return a 1 if the OR statement is TRUE, but return a 2 if the AND statement is TRUE? Thanks! |
#3
|
|||
|
|||
try
=1*(O4=1)+2*And(O4=7,O3<7) or Bob's, with a slight change =IF(O4=1,1,IF(AND(O4=7,O3<7),2,0)) "MrMike" wrote: Hi. Currently I have the following Excel formula, which returns 2 if the statement is TRUE and returns 0 if the statement is FALSE. =if(Or(O4=1,(And(O4=7,O3<7))),2,0) Is it possible to format this statement to return a 1 if the OR statement is TRUE, but return a 2 if the AND statement is TRUE? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |