Formula question
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. |
Formula question
=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 |
All times are GMT +1. The time now is 11:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com