# Need helping with my formula please...

1. ## Need helping with my formula please...

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," ")))))
Thank you!

2. ## RE: Need helping with my formula please...

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

"Altstatten" wrote:

> 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," ")))))
> Thank you!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1