Fill dates Automatically in worksheet cells.
The 1st and 2nd Format are known by Most Excel Users, however, 3rd - 5th Formats are lesser known.
3rd format - Only Weekdays
4th format - Only Months*
5th...
Hi VBA/Macro Learners,
Today we will see how to use FORMAT Function in VBA to get modify the format of Numbers,Dates,Times & String.
Syntax: FORMAT(expression,format,,)
'Ex1: Modify the Format...
Learn Use of MAX function in EXCEL:
Penalty of Rs. 2% or Minimum Rs. 100
Amount
Penalty
Formula
Rs 1000
200
+MAX(1000*2%,100)
Rs 400
100
+MAX(400*2%,100)