I am new and having trouble adding a result from IF function

[NASI]

I am having touble adding a result from IF function
=IF(A1="banana","3",IF(A1="apple","5"))
as a result i am getting this numbers and i would like to add them

thank you in advance

[Pepe Le Mokko]

Hi and welcome
numbers between double quotes are considered text
so try =IF(A1="banana",3,IF(A1="apple",5))

[Richard Buttrey]

Hi and welcome to the forum

Please explain what result you expect for a series of inputs. Create a small excel file and add the results you want for different permutations of fruits.

At the moment A1 only contains EITHER banana or apple, hence what's your logic for adding 3 & 5 which is what I think you're saying but even that isn't clear.

[TMS]

Try

Please Login or Register  to view this content.

[NASI]

3 and 5 were supposed to be price so assume when A1 is banana I get 3 in B1 and A2 is apple I get 5 on B2 and if A3 is banana again i get 3 on B3...what i would like to do is add whatever is on B1,B2,B3 i.e 3+5+3 but that isn't happening.

[NASI]

oh thank u now it works

[NASI]

thank u n i would have given the rep point twice too lol

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[TMS]

You're welcome.

And what value would you want if it is neither apple nor banana?



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.