Return a value for a specific text

[kfanguyjr]

I am trying to get a return value in excel. If cell 07 has an "x" then return 25% esleif p7 has the "x" then return 50% esleif q7 has the "x" then return 75% esleif q7 has the "x" then return 100%

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

assumes "x" exists in one or more cells - modify to account for this not being the case if nec.

[kfanguyjr]

Ok that seems to work. But how can i have it return 0% if there is nothing in the array of cells?

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

or, given use of XL2007

Please Login or Register  to view this content.

[kfanguyjr]

Awesome Thanks!!