Hi
i wrote this formula but it gives me error
=IF(B2>=90, "A", IF(B2>=80, "B", IF(B2>=70, "C","F")))
why?
what is the right?
thanks in advance.
Hi
i wrote this formula but it gives me error
=IF(B2>=90, "A", IF(B2>=80, "B", IF(B2>=70, "C","F")))
why?
what is the right?
thanks in advance.
Looks OK. What kind of error you get?
the error said
the formula you typed contains an error
You don't specify your geo location but perhaps try:
=IF(B2>=90;"A";IF(B2>=80;"B";IF(B2>=70;"C";"F")))
Or alternatively
=LOOKUP(SUM(B2);{0\70\80\90},{"F"\"C\"B"\"A"})
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
The formula works fine provided cell B2 is number format. If it is formatted as text then it gives the wrong result. Are you sure that it is formatted as a number?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=LOOKUP(SUM(B2);{0\70\80\90},{"F"\"C"\"B"\"A"})
gives a message says
the formula you typed contains an error
seco, to repeat earlier point - in which country are located ?
Presently we're guessing the problems are syntax related and that is in effect a waste of everyone's time...
im located in saudi arabia
OK, so either
a) =IF(B2>=90;"A";IF(B2>=80;"B";IF(B2>=70;"C";"F")))
(as advised previously)
or
b) =LOOKUP(SUM(B2);{0,70,80,90};{"F","C","B","A"})
both should work based on your OP though the LOOKUP is perhaps a little more robust (& flexible).
ok this one works well
=LOOKUP(SUM(B2);{0,70,80,90};{"F","C","B","A"})
now if i want to put a sum function instead of "F" and "C" characters ?
like if from 0 to 70 put sum(A1:E1) instead of "F"
how?
thanks in advance.
please outline what you want to do for each scenario
ok
from 0 to 70 sum(A1:A2)
from 70 to 80 sum (A1:A3)
from 80 to 90 sum (A1:A4)
greater than 90 sum(A:A5)
Your thresholds overlap so persuming you mean 0 to < 70, 70 to < 80 etc then
=SUM(A1:INDEX(A2:A5;MATCH(SUM(B2);{0,70,80,90})))
(assumes B2 always >=0 ... if not you can either a) alter 0 to -9.99999999999999E+307 or b) use MAX(0,B2) instead of SUM B2 (you may need to use ; rather than , ))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks