Forum Discussion
IF FORMULA - Help Needed please
I started to try to create a spreadsheet to write and test a formula for you, but realized I don't fully understand the various possible conditions. For one thing, it's not clear whether one can expect that either:
- all three cells (L4, P4 and V4) will be blank, OR
- any one of the three cells, but only one of them, will have a value, OR
- some combination of two OR three of the cells can have a value
In the first case--where they're all blank--it's clear that "Not completed" is the desired result, but it's not clear (to me at any rate), what we're dealing with beyond that. How many of the cells will have a value: only one, any two, all three?
Could you please clarify. If possible, describe the setting, what the context is.
AND, ideally, since you're clearly working with an existing spreadsheet, would you be able to post a copy of that actual spreadsheet along with your explanation, putting it on OneDrive or GoogleDrive, with a link pasted here that grants access to it. Not an image, an actual working spreadsheet.
