Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
Can someone help with If statement.
Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
In C1:
=if(and(A1="Audit",B1=200),"A-200",if(and(A1="Review",B1=60),"C-60,"")) Copy down as required. -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
OOPs!
insert the closing inverted commas " in the formula after C-60 like "C-60". -- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: In C1: =if(and(A1="Audit",B1=200),"A-200",if(and(A1="Review",B1=60),"C-60,"")) Copy down as required. -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
My result was "false". Should there be an "or" in the statement?
-- Many thanks! "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
Still resulted in a "False"
-- Many thanks! "FARAZ QURESHI" wrote: OOPs! insert the closing inverted commas " in the formula after C-60 like "C-60". -- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: In C1: =if(and(A1="Audit",B1=200),"A-200",if(and(A1="Review",B1=60),"C-60,"")) Copy down as required. -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
Wonderful.....it worked. However, if the statement is false, I want the
result to be "n/a" -- Many thanks! "FARAZ QURESHI" wrote: OOPs! insert the closing inverted commas " in the formula after C-60 like "C-60". -- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: In C1: =if(and(A1="Audit",B1=200),"A-200",if(and(A1="Review",B1=60),"C-60,"")) Copy down as required. -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
What value did u insert in A & B for C?
-- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: My result was "false". Should there be an "or" in the statement? -- Many thanks! "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
Instead of "" in the end of the formula insert "n/a"
-- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Wonderful.....it worked. However, if the statement is false, I want the result to be "n/a" -- Many thanks! "FARAZ QURESHI" wrote: OOPs! insert the closing inverted commas " in the formula after C-60 like "C-60". -- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: In C1: =if(and(A1="Audit",B1=200),"A-200",if(and(A1="Review",B1=60),"C-60,"")) Copy down as required. -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
"inverted commas" NICE!!!!
HA, HA, HA!!! "FARAZ QURESHI" wrote in message ... OOPs! insert the closing inverted commas " in the formula after C-60 like "C-60". -- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: In C1: =if(and(A1="Audit",B1=200),"A-200",if(and(A1="Review",B1=60),"C-60,"")) Copy down as required. -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
Instead of "" in the end of the formula insert "n/a"
-- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: What value did u insert in A & B for C? -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: My result was "false". Should there be an "or" in the statement? -- Many thanks! "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR NESTED STATEMENT
Perfect!!!
-- Many thanks! "FARAZ QURESHI" wrote: Instead of "" in the end of the formula insert "n/a" -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Wonderful.....it worked. However, if the statement is false, I want the result to be "n/a" -- Many thanks! "FARAZ QURESHI" wrote: OOPs! insert the closing inverted commas " in the formula after C-60 like "C-60". -- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: In C1: =if(and(A1="Audit",B1=200),"A-200",if(and(A1="Review",B1=60),"C-60,"")) Copy down as required. -- Best Regards, FARAZ A. QURESHI "SuperBee" wrote: Can someone help with If statement. Column A - text entered will be Audit or Review Column B - numbers 0 and higher Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If B = "review" and B is = or 60 then C results as C-60 Many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NESTED IF STATEMENT | New Users to Excel | |||
IF and OR nested statement help | Excel Discussion (Misc queries) | |||
nested what if statement | Excel Worksheet Functions | |||
Nested IF Statement | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions |