I'm hoping you can advise.

I have a formula which compares one data against another and returns a value
of 'met' or 'not met'. What I'd like to include is, if there is no entry in a
particular column (in this case column O), for a value of 'not met' to be
returned.

Here is the formula:

=IF(O29-E29LOOKUP(K29,{"High"},{5}),"Not Met", "Met")

Could what I'm asking for be incorporated into one formula or would I need
separate ones?

Thank you in advance.

=if(o29="","not met",IF(O29-E29LOOKUP(K29,{"High"},{5}),"Not Met", "Met"))

is one way.



Kierano wrote:

I'm hoping you can advise.

I have a formula which compares one data against another and returns a value
of 'met' or 'not met'. What I'd like to include is, if there is no entry in a
particular column (in this case column O), for a value of 'not met' to be
returned.

Here is the formula:

=IF(O29-E29LOOKUP(K29,{"High"},{5}),"Not Met", "Met")

Could what I'm asking for be incorporated into one formula or would I need
separate ones?

Thank you in advance.

--

Dave Peterson