May 26 2019 07:27 AM
I have a problem related to IF function and I need a small assistance with it.
I need to frame condition for following condition:
if park>8,then pay Rs 40+Rs 20 per hour.
I need help to write this condition as value if true in IF function
May 26 2019 09:57 AM
@Debaditya_Sen , and what function shall return if park <= 8 ?
May 26 2019 10:11 AM
It should return a value for parking fee which should be equal to Rs 40+Rs 20 per hour as the total amount in the parking hour is more than 8 hours
May 26 2019 10:49 AM
@Debaditya_Sen , that could be
=40+MAX(0, <Hrs> - 8)*20
where <Hrs> is total number of parking hours