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
=IF(SUM(R5:S5)>6,6,SUM(R5:S5)+IF(O5<80,3,SUM(R5:S5)))
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
=IF(05<80,3,IF(SUM(R5:S5)>6,6,SUM(R5:S5)))
Excelchat Expert
20/07/2018 - 07:19
=IF(O5<80,3,IF(SUM(R5:S5)>6,6,SUM(R5:S5)))
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.