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
@Debaditya_Sen , and what function shall return if park <= 8 ?
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
@Debaditya_Sen , that could be
=40+MAX(0, <Hrs> - 8)*20
where <Hrs> is total number of parking hours