Use Of EOMONTH
Number
|
Rounded Down
| |
1.5
|
1
|
=FLOOR(C4,1)
|
2.3
|
2
|
=FLOOR(C5,1)
|
2.9
|
2
|
=FLOOR(C6,1)
|
123
|
100
|
=FLOOR(C7,50)
|
145
|
100
|
=FLOOR(C8,50)
|
175
|
150
|
=FLOOR(C9,50)
|
What Does It Do ?
This function rounds a value down to the nearest multiple specified by the user.
Syntax
=FLOOR(NumberToRound,SignificantValue)
Formatting
No special formatting is needed.
Example
The following table was used to calculate commission for members of a sales team.
Commission is only paid for every £1000 of sales.
The =FLOOR() function has been used to round down the Actual Sales to the
nearest 1000, which is then used as the basis for Commission.
Name
|
Actual Sales
|
Relevant Sales
|
Commission
|
Alan
|
£23,500
|
£23,000
|
£230
|
Bob
|
£56,890
|
£56,000
|
£560
|
Carol
|
£18,125
|
£18,000
|
£180
|
=FLOOR(D29,1000)
|
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें