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!
|