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%

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

=IF(COUNTIF(O7:R7,"x"),25%*MATCH("x",O7:R7,0),0)

or, given use of XL2007

=IFERROR(25%*MATCH("x",O7:R7,0),0)

[kfanguyjr]

Awesome Thanks!!

[DonkeyOte]

Perhaps:

=25%*MATCH("x",O7:R7,0)
[presumed last instance is R - you repeated Q twice]

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