I need to create a formula that looks at 2 adjacent cells. If both cells show 'YES' then I need the 3 cell to show 'YES'.
If either/both of the 2 adjacent cells are blank then the third needs to be blank.
I need to create a formula that looks at 2 adjacent cells. If both cells show 'YES' then I need the 3 cell to show 'YES'.
If either/both of the 2 adjacent cells are blank then the third needs to be blank.
Last edited by Barbeem; 02-02-2009 at 06:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks