ExcelBanter - IF OR NESTED STATEMENT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF OR NESTED STATEMENT (https://www.excelbanter.com/excel-discussion-misc-queries/178386-if-nested-statement.html)

SuperBee

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!

FARAZ QURESHI

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!

FARAZ QURESHI

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!

SuperBee

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!

SuperBee

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!

SuperBee

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!

FARAZ QURESHI

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!

FARAZ QURESHI

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!

Conan Kelly

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!

FARAZ QURESHI

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!

SuperBee

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!

All times are GMT +1. The time now is 06:50 AM.