Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bring Back DBF! The GIS Industry uses it! | Excel Discussion (Misc queries) | |||
Bring back .dbf in Excel | Excel Discussion (Misc queries) | |||
Need to bring back Average using either Sumproduct or CSE formula | Excel Discussion (Misc queries) | |||
Bring back the FORMULA RESULT BAR in excel | New Users to Excel | |||
Bring Back Qualified Sum from another WB | Excel Worksheet Functions |