Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello, I need to make several @ if Statements within one cell. =IF(SUM(R5:S5)>6,6,SUM(R5:S5)+IF(O5<80,3,SUM(R5:S5))) This is the formula I have come up with, but it's not working. Are you able to figure out what I've done wrong? It should say, if the sum is > 6 then 6 if not then the sum of r5&s5 also if o5 is less than 80 then 3 if not then the sum of r5 and s5 Are you able to helP?
Solved by Z. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 20/07/2018 - 07:04
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)
User 20/07/2018 - 07:04
Great, thanks!
Excelchat Expert 20/07/2018 - 07:04
Okay, I've seen your query and it seems you need help in fixing your formula. May I know on what cell is the formula entered?
User 20/07/2018 - 07:05
Sure T5
User 20/07/2018 - 07:06
Excelchat Expert 20/07/2018 - 07:07
What I'm actually confused at is the part of this one: IF(O5<80,3,SUM(R5:S5))
Excelchat Expert 20/07/2018 - 07:08
Do you want to add the output value of this to the output value of =IF(SUM(R5:S5)>6,6,SUM(R5:S5))?
User 20/07/2018 - 07:08
It's for leaves taken, if they have 80 sick days they can carryover their personal days up to 3 if not they only get 3 new sick days not the carry over
Excelchat Expert 20/07/2018 - 07:09
Oh I see.
User 20/07/2018 - 07:09
I don't want to add the output value, I want it to check to see if they have less than 80 sick days
User 20/07/2018 - 07:09
if they don't, then i want it to be just the 3 new personal days given
User 20/07/2018 - 07:11
Sorry, if they "do" not if they "don't"
Excelchat Expert 20/07/2018 - 07:12
Okay, let me try to reconfigure your formula to return the correct computation. We can then check if it was configured correctly. :)
User 20/07/2018 - 07:12
Sick CO Sck New Sick Bal P/L CO P/L New P/L Bal 129.50 18.00 138.00 3.00 3.00 6.00 n/a n/a n/a n/a n/a n/a 137.50 18.00 138.00 6.00 3.00 6.00 26.25 18.00 44.25 1.00 3.00 7.00
Excelchat Expert 20/07/2018 - 07:13
Oh sorry, it seems the chatbox distorted the format of the values you've pasted. Will it be okay if you paste them over to the document preview to the right? Thanks!
User 20/07/2018 - 07:14
t5 is f22 now
Excelchat Expert 20/07/2018 - 07:16
Is 7 the supposed value on F22 if we are to manually compute for it? :)
User 20/07/2018 - 07:16
No, it should be 3 because they have less than 80 sick days
User 20/07/2018 - 07:17
f21 should be 6, f19 should be 6
Excelchat Expert 20/07/2018 - 07:17
Oh I see. I get now. Thanks so much for patiently clarifying this. Let me work on it and update you the soonest!
Excelchat Expert 20/07/2018 - 07:18
Already done! Please refer to cell F22 for the corrected formula. I as well verified this with F19 and F21 cells.
Excelchat Expert 20/07/2018 - 07:19
If we are to edit your original formula posted, it should look like this:
Excelchat Expert 20/07/2018 - 07:19
Excelchat Expert 20/07/2018 - 07:19
User 20/07/2018 - 07:20
Yay!! You are wonderful. Thanks SO much!!
Excelchat Expert 20/07/2018 - 07:20
Basically, before anything else, it would first check on cell O5 prior to checking the SUM(R5:S5).
Excelchat Expert 20/07/2018 - 07:21
Is there anything else that I can assist you regarding the solution provided? :)
User 20/07/2018 - 07:21
Okay, that makes sense. I really appreciate your help! Enjoy your day!
Excelchat Expert 20/07/2018 - 07:21
Nice! You can now end the session via the button on your upper right (sorry, can't do it from our end). I would also appreciate it if you can leave a great feedback after this.Thanks so much for using Got it pro and have a nice day! :)
Excelchat Expert 20/07/2018 - 07:24
Hello, if all is good now, you may end the session by clicking the END SESSION on the upper right of your screen. Also, I'd appreciate if you could drop a few lines for your kind and honest feedback on a survey after this session. Many thanks and have a good day!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc