I have an IF function in excel that goes like this: =IF(d5=yes,c5+$b$22,c5)
I need the function to recognize whether or not d5 says yes or no, specifically just yes.
If anyone could help me fix this problem, it would be much appreciated. Thanks
I have an IF function in excel that goes like this: =IF(d5=yes,c5+$b$22,c5)
I need the function to recognize whether or not d5 says yes or no, specifically just yes.
If anyone could help me fix this problem, it would be much appreciated. Thanks
put quotes around "yes".
=IF(d5="yes",c5+$b$22,c5)
Last edited by protonLeah; 03-29-2013 at 07:41 PM.
Ben Van Johnson
Maybe something like this :
=IF(D5="yes",C5&$B$22,C5)
Hope this helps
Edit-
or
if C5 and B22 are numbers:
=IF(D5="yes",C5+$B$22,C5)
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks