Home

IF Function help!

%3CLINGO-SUB%20id%3D%22lingo-sub-648652%22%20slang%3D%22en-US%22%3EIF%20Function%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-648652%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20problem%20related%20to%20IF%20function%20and%20I%20need%20a%20small%20assistance%20with%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20frame%20condition%20for%20following%20condition%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20park%26gt%3B8%2Cthen%20pay%20Rs%2040%2BRs%2020%20per%20hour.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20to%20write%20this%20condition%20as%20value%20if%20true%20in%20IF%20function%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-648652%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-648790%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-648790%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349062%22%20target%3D%22_blank%22%3E%40Debaditya_Sen%3C%2FA%3E%26nbsp%3B%2C%20and%20what%20function%20shall%20return%20if%20park%20%26lt%3B%3D%208%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-648793%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-648793%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20should%20return%20a%20value%20for%20parking%20fee%20which%20should%20be%20equal%20to%20Rs%2040%2BRs%2020%20per%20hour%20as%20the%20total%20amount%20in%20the%20parking%20hour%20is%20more%20than%208%20hours%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-648814%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-648814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349062%22%20target%3D%22_blank%22%3E%40Debaditya_Sen%3C%2FA%3E%26nbsp%3B%2C%20that%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3D40%2BMAX(0%2C%20%26lt%3BHrs%26gt%3B%20-%208)*20%3C%2FPRE%3E%0A%3CP%3Ewhere%26nbsp%3B%3CHRS%3E%20is%20total%20number%20of%20parking%20hours%3C%2FHRS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Debaditya_Sen
New 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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies