I am trying to get a sum of an if statement. I am using the basic sum() function and it does not give me any value. I am not sure why. I used the if stmt below to get values and what to get the total. please advise on what i am doing wrong.
=IF(A2=1,"$10.00",IF(A2=0,"$ 0.00"))
Hi
Your formula works fine for me..
Take a look to the attachement
Regards
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
By enclosing the "values" in quotes, you make them text...not numbers.
Try this:
=IF(A2=1,10,IF(A2=0,0))
However, your formula is incomplete.
It does not cover other possibilities for A2.
If A2 can only be 0 or 1, then perhaps this will work better;
=A2*10
Does any of that help?
Great!!!! I removed the quotation marks and it worked!!!!!!!!!!!
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks