Well, this is a simple question really.
In Excel 2010, why isn't the =IF function working? What I am typing in is:
What I am trying to do is if any cell between the area of G5 and W13 has the exact value of $20 (all of the cells are set to text format Currency, before anyone corrects me) it will show nothing. Though if there isn't any cells that have the value of $20, it will just show $20 on that particular cell.
After experimenting, the culprit is it saying
G5:W13. I'm okay typing all the cells between that area, so I did do that. However, it tells me that I have an error in my formula when I do that, so therefore I am stuck.
Is there a way from it to stop correcting either of those? All help is appreciated. :)