I have a #Value error with the following IF function,
Can anyone identify the error;
=IF(G2="C2",Start!G10,"Not Applicable"),IF(G2="Q2",Start!G10,"Not Applicable")
I have a #Value error with the following IF function,
Can anyone identify the error;
=IF(G2="C2",Start!G10,"Not Applicable"),IF(G2="Q2",Start!G10,"Not Applicable")
=IF(G2="C2",Start!G10,IF(G2="Q2",Start!G10,"Not Applicable"))
or =IF(OR(G2={"c2","q2"}),start!G10,"not applicable")
if c2 or q2 are other cells then it needs to be
=IF(G2=C2,Start!G10,IF(G2=Q2,Start!G10,"Not Applicable"))
Last edited by martindwilson; 07-16-2012 at 05:23 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi
Did you try without ""?
=IF(G2=C2,Start!G10,"Not Applicable"),IF(G2=Q2,Start!G10,"Not Applicable")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
fotis,it's entirely the wrong construction for nested IF
Yes Martin. You are correct.
..Fast response..No checked.. Apologize for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks