Formula won't work

  • Thread starter Thread starter Neuther
  • Start date Start date
N

Neuther

i have this formula

=IF(Skills!AP2=x,MIN(ROUND((0.5*C6-5.2549),0),5),ROUND((0.5*C6-5.2549),0))

i can't figure out what's wrong w/ this, when i hit enter i get

#name?

i don't know if more info is needed since i'm not sure what's wrong w
it.

Any help would be appriciated
 
Hi

I think the problem is with the x
in Skills!AP2=x

if the x is supposed to be an x out of the alphabet then you need it to be
written as "x" as in
Skills!AP2="x"

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top