If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
i want to create an IF formula to bring back one of four results .
. . . which would be dependant on the value of the cell.
eg. 0-5 = 45% 6-12 = 33% 13-20 = 25% 21 = 20% i want the formula to automatically return the correct percentage, can anyone tell me how the formula should look please? thanks, Vicky |
#2
|
|||
|
|||
i want to create an IF formula to bring back one of four results .
something like
=if(a121,.2,if(a113,.25,if(a16,.33,if(a1=0,.45 ,"")))) -- Don Guillett Microsoft MVP Excel SalesAid Software "vsors" wrote in message ... . . . which would be dependant on the value of the cell. eg. 0-5 = 45% 6-12 = 33% 13-20 = 25% 21 = 20% i want the formula to automatically return the correct percentage, can anyone tell me how the formula should look please? thanks, Vicky |
#3
|
|||
|
|||
i want to create an IF formula to bring back one of four resul
thank you both so much for the help - worked first time!
"Pete_UK" wrote: Assume you have those values in A1, put this in B1: =IF(A120,20%,IF(A112,25%,IF(A15,33%,IF(A1=0,45 %,"n/a")))) Hope this helps. Pete On Aug 26, 3:13 pm, vsors wrote: . . . which would be dependant on the value of the cell. eg. 0-5 = 45% 6-12 = 33% 13-20 = 25% 21 = 20% i want the formula to automatically return the correct percentage, can anyone tell me how the formula should look please? thanks, Vicky |
#4
|
|||
|
|||
i want to create an IF formula to bring back one of four resul
You're welcome - thanks for feeding back.
Pete On Aug 26, 3:36*pm, vsors wrote: thank you both so much for the help - worked first time! |
#5
|
|||
|
|||
i want to create an IF formula to bring back one of four results .
One more to work with.
=LOOKUP(B1,{0,6,13,21},{0.45,0.33,0.25,0.2}) Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 07:13:01 -0700, vsors wrote: . . . which would be dependant on the value of the cell. eg. 0-5 = 45% 6-12 = 33% 13-20 = 25% 21 = 20% i want the formula to automatically return the correct percentage, can anyone tell me how the formula should look please? thanks, Vicky |
Thread Tools | |
Display Modes | |
|
|