Hi everyone,
I have the following formula:
=IF(AND(F5="Initial",F10="Core",Data!E2),"")
Right now, F5 does equal Initial and F10 does equal Core, but I'm still getting a "" result. Any idea what I'm doing wrote? I seem to be getting the opposite result I'm looking for.
Thanks,
Try
Formula:
=IF(AND(F5="Initial",F10="Core"),Data!E2,"")
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.
Misplaced paren:
=IF(AND(F5="Initial",F10="Core"), Data!E2,"")
Entia non sunt multiplicanda sine necessitate
=IF(AND(F5="Initial",F10="Core",Data!E2),"")
you dont have what
data!E2 should be in the AND statement
you also do not have a false statement - so if false you will get FALSE
=IF(AND(F5="Initial",F10="Core",Data!E2=???),"", "what is required for false condition")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks