Hi There,
Based on documentation I've found through Microsoft and elsewhere I see that I can make a IF statement which reads a string in a cell and gives a true or false output.
I believe I have all the syntax correct, but I'm getting a false output no matter what. Here's a screenshot of what I'm dealing with..
https://dl.dropboxusercontent.com/u/...2015.43.23.png
I'm using Excel 2016. Cell B5 has a value of 'yes' and my formula in B6 is =IF(B5="yes", 100, 50)
So I'm expecting an output of 100, but all I'm getting in 50. Any clue to what's happening/what I'm doing wrong?
Thanks a bunch for your help.
Bookmarks