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 Chriss Miller 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
Joined
May 30, 2001
Messages
3
Location
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

BxWill
  • Question Question
MS EXCEL 2016 LINE CHART NOT DROP TO ZERO - USING NESTED IF AND COUNTIF
Replies
1
Views
53
combo
combo
Swi
  • Locked
  • Question Question
Excel Webservice
Replies
2
Views
811
mintjulep
M
cneill
  • Locked
  • Question Question
Combining If and Iferror and Index/Match with Hyperlink
Replies
18
Views
1K
cneill
cneill
Damnitalldaddy
  • Locked
  • Question Question
excel formulas
Replies
1
Views
304
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
784
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top