Hey in google excel when i use this statement it works
=IF(D5="win", "3", IF(D5="draw", "1", IF(D5="lose", "0", "")))
but i want to use it with a value for example
=IF(D5="3", "3", IF(D5="2", "1", IF(D5="6", "8", "")))
but when i use this it wont work, any ideas why not / a fix?
Why do you have quotes around the 3? why not just D5=3?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
that fixes it thank you, i thought i needed them guess not, thanks for help.
I believe the quotes make the number a text number, so it isn't the same.
ok cool thanks for that +1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks