Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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(L799,P$7,(IF(L7<50,R$7,(IF(L750<100,Q$7," "))))) Please help me with what I'm doing wrong. Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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(L799,P$7,(IF(L7<50,R$7,(IF(L750<100,Q$7," "))))) Please help me with what I'm doing wrong. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |