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!

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

excel if(and formulas

Status
Not open for further replies.
soda

soda

Technical User
May 30, 2001
3
US
I know excel can do if(and(... formulas..&nbsp;&nbsp;My question is: are there in similar formulas for vlookup or sumif?&nbsp;&nbsp;ie sumif ( this and that are true)...&nbsp;&nbsp;vlookup ( multi condition )...&nbsp;&nbsp;?<br><br>Help & Thanks,<br>John
 
Sort by date Sort by votes
Hello Soda/John,<br><br>Yes, Yes and Yes,<br><br>Excel does have the functions you are looking for. Try this: &quot;Insert&quot; select &quot;Function&quot; or use the &quot;Paste Function&quot; button from the Standard Toolbar.<br><br>Within the Paste Function Dialog box you will no doubt find the Functions you are looking for.<br><br>Good Luck
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cneill
  • Locked
  • Question
Combining If and Iferror and Index/Match with Hyperlink
Replies
18
Views
328
cneill
cneill
Damnitalldaddy
  • Locked
  • Question
excel formulas
Replies
1
Views
82
mintjulep
M
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
290
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
287
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
861
shytott
shytott

Part and Inventory Search

Sponsor

Back
Top