Need helping with my formula please...

A

Altstatten

I have three cells designated P7, Q7, and R7 with a line of text in each. In
another cell (L7) I have a percentage. My formula is in M7. If the percentage
in L7 drops below 50% I want the text in R7 displayed, it's between 50% and
100%, I want the text in Q7 displayed, and if it's 100% or above, I want P7
displayed. The formula I have is as follows:
=IF(L7>99,P$7,(IF(L7<50,R$7,(IF(L7>50<100,Q$7," ")))))
Please help me with what I'm doing wrong.
Thank you!
 
B

bpeltzer

It looks like you're ignoring the %s in your if statement, and you've made
the final portion of the if overly complex (and syntactically invalid). Try
=if(l7>=100%,p$7,if(l7>=50%,q$7,r$7))
 

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

Top