IF Function help!

Copper Contributor

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

3 Replies

@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