=IF(D3=B3+C3,"Correct","Wrong") ive got this formula what should I add so whenever the blank CELL is present it wont show the false value WRONG
=IF(D3=B3+C3,"Correct","Wrong") ive got this formula what should I add so whenever the blank CELL is present it wont show the false value WRONG
Last edited by ragnaedge; 08-23-2013 at 11:36 AM.
Hi and welcome to the forum,
Most people who do post here do!. i.e need help we take that as a given.
Unfortunately your post does not comply with Rule 1 of our Forum. RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
=IF(OR(ISBLANK(B3),ISBLANK(C3),ISBLANK(D3)),"Correct",IF(D3=B3+C3,"Correct","Wrong"))
the only cell that is blank is D3 it should be left blank to input the answers...
ive tried your formula but it seems when i left the cell blank it shows correct what i wanted is when D3 is blank the cell where the formula is should be blank too using this formula =IF(D3=B3+C3,"Correct","Wrong")
Last edited by ragnaedge; 08-23-2013 at 11:23 AM.
@ragnaedge & Eric,
Please note the forum rules about thread titles. You should not be responding to inadequate titles.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks