Hi, I'm pretty new to using if functions, so this might be a simple question. I am creating a database for others to enter data into. I would like for a cell to read "skipped," if the response in another cell is 0 (NOT if it is blank). Right now the formula I'm trying is:
=IF(DY3=0, "skipped", "")
However, the cell is showing the word "skipped" even if DY3 is blank (no "0" typed in). I only want the word skipped to appear if a 0 is actually typed in the cell. Help!
Try =IF(or(isblank(DY3), DY3<>0), "", "skipped")
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Thanks, shg! Worked like a charm
Dear Daniela11,
I think, you have got the solution.
If so, please mark your post as "SOLVED". To do this, go to your first post, click "Edit" button, then click, "Go Advanced", then Select prefix "SOLVED" and then SAVE.
This will enable other users/moderators not to repeatedly open the Thread unnecessarily.
Good friends are hard to find, harder to leave, and impossible to forget.
acsishere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks