AUTOEXCEL [Automation Excellence]
Ads
Sunday, 6 May 2018
If(Or())
If with Or helps to add multiple conditions where one of the criteria is required to be meet/fulfilled.
In the below example if cell name is either yellow or green the formula with return value as true or in any other case 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