IF Function help!

Question

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

sergeibaklan · Answer

Debaditya_Sen&nbsp;, that could be
=40+MAX(0, &lt;Hrs&gt; - 8)*20
where&nbsp;&lt;Hrs&gt; is total number of parking hours

sergeibaklan · Answer

Debaditya_Sen&nbsp;, and what function shall return if park &lt;= 8 ?

debaditya_sen · Answer

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

Forum Discussion