How to check all three cells are greater than 0% and then lookup v

  • Thread starter Thread starter Len
  • Start date Start date
L

Len

I have a spreadsheet which references 8 others and has data loaded from
another system.

I am trying to get the final part of the worksheet to check the three fields
(which are IF/VLOOKUPS) are ALL greater than 0%.

If they are then the function is to do one final VLOOKUP to return another %.

I have no problems with using IF or VLOOKUP and I have tried AND which
always produces a TRUE response even if one or two of the cells are empty or
zero. I can not see how LOOKUP would work and I would need more that 7 IF
statements trying that route.

Your help would be appreciated as this will save one person manually
calculating figures for over 1/2 day in HR.

Thanks in advance
 
Mike H

Thank you for your reply. However it returns the VLOOKUP when one of the
cells is zero.

Re-reading my original note I may have caused confusion so I will try again:

Each of the cells must be greater than 0% before I pull through the VLOOKUP.

A1 B1 C1
0% 5% 7% False no VLOOKUP
3% 5% 7% True perform VLOOKUP

Hope this helps you?

Thanks in advance
 
len,

That's what my formula did. here it is again with the ranges corrected.

=IF(MIN(A1:C1)>0,"do this lookup","Don't do lookup")

Mike
 
Alan/Mike

Thank you for your help but I had tried both of your suggestions and it
still picks up the VLOOKUP even if one or two cells are blank or Zero.

Could it be the Excel settings?
 
Oh yes, I see what you mean. What about:
=IF(AND(MIN(A1:C1)>0,NOT(ISBLANK(A1)),NOT(ISBLANK(B1)),NOT(ISBLANK(C1))),"Yes","No")
 
Mike

Thank you for your help but I had tried your suggestion and it
still picks up the VLOOKUP even if one or two cells are blank or Zero.

Could it be the Excel settings?
 
Back
Top