| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to write an `IF` and an `OR` formula
Hi,
I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Hi,
The correct syntax for or is =IF(OR(H751,I75<1),"A","") But in your question you say if BOTH are false so do you mean AND =IF(AND(H751,I75<1),"A","") Mike "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Hi Mike,
I actually mean "If either are true" then put in an "A" (that is, they don`t have to both be true) Thanks RR1 "Mike H" wrote: Hi, The correct syntax for or is =IF(OR(H751,I75<1),"A","") But in your question you say if BOTH are false so do you mean AND =IF(AND(H751,I75<1),"A","") Mike "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Take a look at the below link
http://www.excelfunctions.net/ExcelOrFunction.html If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
In that case the OR formula I posted does what you want
Mike "Romileyrunner1" wrote: Hi Mike, I actually mean "If either are true" then put in an "A" (that is, they don`t have to both be true) Thanks RR1 "Mike H" wrote: Hi, The correct syntax for or is =IF(OR(H751,I75<1),"A","") But in your question you say if BOTH are false so do you mean AND =IF(AND(H751,I75<1),"A","") Mike "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Missed to copy the below..
http://www.excelfunctions.net/ExcelIf.html If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Take a look at the below link http://www.excelfunctions.net/ExcelOrFunction.html If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
"Jacob Skaria" wrote in message ... Missed to copy the below.. http://www.excelfunctions.net/ExcelIf.html Where it says nothing about AND/OR in an IF function! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Bob, from the query I fealt that the OP only seem to have a problem with OR
function. Should have been...Thanks.. =IF(AND(condition1,condition2,...), TRUE statement, FALSE statement) =IF(OR(condition1,condition2,...), TRUE statement, FALSE statement) "Bob Phillips" wrote: "Jacob Skaria" wrote in message ... Missed to copy the below.. http://www.excelfunctions.net/ExcelIf.html Where it says nothing about AND/OR in an IF function! |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
<G The site looks quite good, but that page was just no help for this
question. Where are you Jacob, you seem to post quite early my time (UK). -- __________________________________ HTH Bob "Jacob Skaria" wrote in message ... Bob, from the query I fealt that the OP only seem to have a problem with OR function. Should have been...Thanks.. =IF(AND(condition1,condition2,...), TRUE statement, FALSE statement) =IF(OR(condition1,condition2,...), TRUE statement, FALSE statement) "Bob Phillips" wrote: "Jacob Skaria" wrote in message ... Missed to copy the below.. http://www.excelfunctions.net/ExcelIf.html Where it says nothing about AND/OR in an IF function! |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Still stuck! Can anyone help.
Need to know ..... If either statement is true then put an "A", otherwise leave blank. Thanks "Romileyrunner1" wrote: Hi Mike, I actually mean "If either are true" then put in an "A" (that is, they don`t have to both be true) Thanks RR1 "Mike H" wrote: Hi, The correct syntax for or is =IF(OR(H751,I75<1),"A","") But in your question you say if BOTH are false so do you mean AND =IF(AND(H751,I75<1),"A","") Mike "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Have you tried the below formula Mike has posted ?
=IF(OR(H751,I75<1),"A","") In general 'AND() returns true only if all conditions are satisfied =IF(AND(condition1,condition2,...), TRUE statement, FALSE statement) 'OR() returns true if any one of the condition is met =IF(OR(condition1,condition2,...), TRUE statement, FALSE statement) If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: Still stuck! Can anyone help. Need to know ..... If either statement is true then put an "A", otherwise leave blank. Thanks "Romileyrunner1" wrote: Hi Mike, I actually mean "If either are true" then put in an "A" (that is, they don`t have to both be true) Thanks RR1 "Mike H" wrote: Hi, The correct syntax for or is =IF(OR(H751,I75<1),"A","") But in your question you say if BOTH are false so do you mean AND =IF(AND(H751,I75<1),"A","") Mike "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Thanks Mike.
works fine now. RR1 "Mike H" wrote: In that case the OR formula I posted does what you want Mike "Romileyrunner1" wrote: Hi Mike, I actually mean "If either are true" then put in an "A" (that is, they don`t have to both be true) Thanks RR1 "Mike H" wrote: Hi, The correct syntax for or is =IF(OR(H751,I75<1),"A","") But in your question you say if BOTH are false so do you mean AND =IF(AND(H751,I75<1),"A","") Mike "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Thnaks for your time Jacob.
Yep, that`s the one. Cheers RR1 "Jacob Skaria" wrote: Have you tried the below formula Mike has posted ? =IF(OR(H751,I75<1),"A","") In general 'AND() returns true only if all conditions are satisfied =IF(AND(condition1,condition2,...), TRUE statement, FALSE statement) 'OR() returns true if any one of the condition is met =IF(OR(condition1,condition2,...), TRUE statement, FALSE statement) If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: Still stuck! Can anyone help. Need to know ..... If either statement is true then put an "A", otherwise leave blank. Thanks "Romileyrunner1" wrote: Hi Mike, I actually mean "If either are true" then put in an "A" (that is, they don`t have to both be true) Thanks RR1 "Mike H" wrote: Hi, The correct syntax for or is =IF(OR(H751,I75<1),"A","") But in your question you say if BOTH are false so do you mean AND =IF(AND(H751,I75<1),"A","") Mike "Romileyrunner1" wrote: Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I75<1,"A",("")) Meaning, If value in H75 1 OR if value in I75<1, then put in an `A` otherwise if both statements are false, then leave blank. Any ideas guys? Thanks RR1 |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
Bob, I have sent you an email @ tiscali.. Not sure whether that is still
valid... "Bob Phillips" wrote: <G The site looks quite good, but that page was just no help for this question. Where are you Jacob, you seem to post quite early my time (UK). -- __________________________________ HTH Bob "Jacob Skaria" wrote in message ... Bob, from the query I fealt that the OP only seem to have a problem with OR function. Should have been...Thanks.. =IF(AND(condition1,condition2,...), TRUE statement, FALSE statement) =IF(OR(condition1,condition2,...), TRUE statement, FALSE statement) "Bob Phillips" wrote: "Jacob Skaria" wrote in message ... Missed to copy the below.. http://www.excelfunctions.net/ExcelIf.html Where it says nothing about AND/OR in an IF function! |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to write an `IF` and an `OR` formula
No Jacob, this email has stopped delivering some time ago (although oddly I
can send from it!). Try me on bob at xldynamic dot com (do the obvious). -- __________________________________ HTH Bob "Jacob Skaria" wrote in message ... Bob, I have sent you an email @ tiscali.. Not sure whether that is still valid... "Bob Phillips" wrote: <G The site looks quite good, but that page was just no help for this question. Where are you Jacob, you seem to post quite early my time (UK). -- __________________________________ HTH Bob "Jacob Skaria" wrote in message ... Bob, from the query I fealt that the OP only seem to have a problem with OR function. Should have been...Thanks.. =IF(AND(condition1,condition2,...), TRUE statement, FALSE statement) =IF(OR(condition1,condition2,...), TRUE statement, FALSE statement) "Bob Phillips" wrote: "Jacob Skaria" wrote in message ... Missed to copy the below.. http://www.excelfunctions.net/ExcelIf.html Where it says nothing about AND/OR in an IF function! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how would I write a formula | Excel Discussion (Misc queries) | |||
| I need to Write a Formula | Excel Worksheet Functions | |||
| how to write a formula | New Users to Excel | |||
| how to write a formula | New Users to Excel | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Linear Mode
