Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 419
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NESTED IF STATEMENT SSJ New Users to Excel 4 January 16th 08 09:21 PM
IF and OR nested statement help [email protected] Excel Discussion (Misc queries) 4 July 16th 07 10:22 PM
nested what if statement brian Excel Worksheet Functions 1 April 23rd 07 12:11 AM
Nested IF Statement Secret Squirrel Excel Discussion (Misc queries) 8 November 19th 06 03:43 AM
7+ nested if statement? Turi Excel Worksheet Functions 3 December 20th 04 08:55 PM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"