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

[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]

Len,

use MIN

=IF(MIN(A1:A3)>0,"do this lookup","Do something else")

Mike

 

[Len]

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

 

[Alan Moseley]

Surely you just need:-
=IF(AND(A1>0,B1>0,C1>0),VLOOKUP(etc),"")

 

[Mike H]

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

 

[Len]

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?

 

[Alan Moseley]

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")

 

[Len]

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?