• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF function question

Mariya

New Member
Hi everybody!
I calculate fees fof kids visiting kindergarten. The maximum fee which the parent should pay is $48. Sometimes depends on the month's days the maximum fee is between $47 and $48. The problem is when I have such calculation I need to repair the cell which has more than $47 and less than $48 by hand. I decided to use IF function and I did the following =IF(47.94<H11<48;[48];[H11]). And of course there was an error. If the value is less than 47.94 I just need it to be the same value as H11. Where is my mistake? I attach the file
 

Attachments

  • IF function question.docx
    151.9 KB · Views: 7
  • IF function question.xlsx
    10.6 KB · Views: 8
I'm not understanding what you want to happen. Please explain in simple English what you wish to happen using the example you have posted. Use your spreadsheet and give a couple of examples.
 
Back
Top