Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel If function

Status
Not open for further replies.

craiogram

MIS
Feb 20, 2004
126
US
I have placed this coding in the formula bar:
=IF(C2="Card",B18,"")
which works fine. The problem is that I need to evaluate more than 1 value such as:
=IF(C2="Card" & D17=5,B18,"")

But this does NOT work. If I remove C2 or D17 it works but together it does not. Can someone please suggest something?

Thank you in advance!
 
Please Disregard!!!!

I have figured it out..........


I jumped the gun...

thank you anyway!

Take care to all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top