#1
|
|||
|
|||
IFS formula
Hi. I've got to calculate multiple If on a formula, but I don't know what is wrong with my formula. Tks for answer.
|
#2
|
|||
|
|||
Neither do we, because you did not explain what it is that you perceive to be "wrong". Perhaps it is: your formula only returns 400 or "fără bursă". Your formula is: =IFS(Q26>=8.5,400,Q26>=9,500,Q26>=9.5,600,Q26=10,1 000,Q26<=8.49,"fără bursă") With Q26 = 9.03125, presumably you expect 500, not 400. But when Q26>=9 is true, Q26>=8.5 is also true. And since IFS stops with the first true condition left-to-right, Q26>=8.5 will "win", and IFS will return 400. You should re-order your conditions, to wit: =IFS(Q26=10, 1000, Q26>=9.5, 600, Q26>=9, 500, Q26>=8.5, 400, TRUE, "fără bursă") The use of TRUE obviates the need to test Q26<=8.49. And that is a good thing, because 8.49 is not the next value before 8.5, since you do not round the AVERAGE. Alternatively: =LOOKUP(Q26, {0, 8.5, 9, 9.5, 10}, {"fără bursă", 400, 500, 600, 1000}) |
#3
|
||||
|
||||
Hi, your test order is not correct see attached
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Hi guys! Thanks a lot both of you, because you've answer so quickly to my message. I'm a newbie on Excel, I'm trying to learn everyday. I will try your suggestions to see if it works as it should be.
In the future surely I will have more questions for you. Have a blessed day! |
#5
|
|||
|
|||
Yep, It works like a charm. Tks so much!
|
#6
|
||||
|
||||
I marked this thread as "solved" for you..
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula Copy Row 2 Row But Next Column In Formula From Another Tab | TimG | Excel | 3 | 04-16-2018 09:20 PM |
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula | innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
Formula Help | clo312 | Excel | 11 | 01-11-2014 02:54 AM |
Formula Help | OTPM | Excel | 5 | 02-21-2013 08:03 AM |