AUTOEXCEL [Automation Excellence]
Ads
Thursday, 10 May 2018
If(And())
If with And helps to add multiple conditions where all condition are required to be meet/fulfilled.
In the below example if first cell name is yellow and the other is green then the formula with return value as true or false.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Sumifs()
This formula helps to sumup based on multiple criteria. It is same as sumif but sumif support only one condition whereas sumif support mul...
Excel Shortcuts
Copy= Ctrl+C Paste= Ctrl+V Paste Value= Menu Key(key between Windows key & Ctrl.)+V Paste Formula= Menu Key(key between Windows key ...
No comments:
Post a Comment