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.
Try
Please Login or Register to view this content.
Ed
_____________________________
Always learning, but never enough!
_____________________________
Cheers -all is great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks