| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what function to use
Hi
I'm creating a spreadsheet with percentages in one column and in the next column i need to a specific word according the value of the percentage. For example anything above 70% needs to be called fixed anything above 50% but lower than 70% needs to be called flexible etc etc Can anyone help with this please? Thanks a lot! Phil |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what function to use
try
=if(a2.7,"fixed",if(a2.5,"flexible","")) -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... Hi I'm creating a spreadsheet with percentages in one column and in the next column i need to a specific word according the value of the percentage. For example anything above 70% needs to be called fixed anything above 50% but lower than 70% needs to be called flexible etc etc Can anyone help with this please? Thanks a lot! Phil |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what function to use
If you had a percentage in A1, put this in B1
=IF(A10.7,"Fixed",If(A10.5,"Flexible","")) " wrote: Hi I'm creating a spreadsheet with percentages in one column and in the next column i need to a specific word according the value of the percentage. For example anything above 70% needs to be called fixed anything above 50% but lower than 70% needs to be called flexible etc etc Can anyone help with this please? Thanks a lot! Phil |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what function to use
On Aug 25, 3:04*pm, "Don Guillett" wrote:
try =if(a2.7,"fixed",if(a2.5,"flexible","")) -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... Hi I'm creating a spreadsheet with percentages in one column and in the next column i need to a specific word according the value of the percentage. For example anything above 70% needs to be called fixed anything above 50% but lower than 70% needs to be called flexible etc etc Can anyone help with this please? Thanks a lot! Phil- Hide quoted text - - Show quoted text - thanks for that!!!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what function to use
If you have many different possible options, you can also create a table with
your percents and the desired return value: A B ..5 flexible ..7 fixed and do =vlookup(yourvalue,A:B,2) to return flexible for any value between .5 and .6999999999 and fixed for values .7+ In the above example, anything < .5 would return an error, so presumably, you'll want somethign for value 0. "Don Guillett" wrote: try =if(a2.7,"fixed",if(a2.5,"flexible","")) -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... Hi I'm creating a spreadsheet with percentages in one column and in the next column i need to a specific word according the value of the percentage. For example anything above 70% needs to be called fixed anything above 50% but lower than 70% needs to be called flexible etc etc Can anyone help with this please? Thanks a lot! Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
