VinceF
Board Regular
- Joined
- Sep 22, 2007
- Messages
- 192
- Office Version
- 2016
- Platform
- Windows
Greetings,
This should be an easy one for the experts.
In cell G12 the result of the formula is 54, I tried every conceivable way that I can think of to configure the formula so that the Floor function rounds the 54 to 50
Appreciate you for your assistance.
VinceF
Excel 2016
=IF(K12=1,PAY!$C$27,IF(K12=2,PAY!$D$27,IF(K12=3,PAY!$E$27,FLOOR(G12,5))))
This should be an easy one for the experts.
In cell G12 the result of the formula is 54, I tried every conceivable way that I can think of to configure the formula so that the Floor function rounds the 54 to 50
Appreciate you for your assistance.
VinceF
Excel 2016
=IF(K12=1,PAY!$C$27,IF(K12=2,PAY!$D$27,IF(K12=3,PAY!$E$27,FLOOR(G12,5))))
