Hi,
I would like a formula which looks within a number of columns and only if all columns are complete then it would return a Yes.
Can any one help with the formula please?
I have uploaded an example of what I need
Hi,
I would like a formula which looks within a number of columns and only if all columns are complete then it would return a Yes.
Can any one help with the formula please?
I have uploaded an example of what I need
In E8 & copy down
=IF(COUNTBLANK(F8:H8) = 0, "Yes", "")
There are alternatives, this is probably the easiest to understand when viewing the formula
is it only the three columns
counta(f8:h8)
will count the cells that are not blank
so
=IF(counta(f8:h8)=3, "yes", "")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
You could put this formula in E8:
=IF(COUNTA(F8:H8)=3,"YES","")
then copy it down.
Hope this helps.
Pete
Thanks all, all solutions worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks