| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(logical_test, may be a number or text
The calculated value in cell L20 may be a number or a customized error
string/text message. In cell D20 I need to display the text in in L20 if that is the result, or if a number is calculated and number calculated is greater than 500, display 500, of if a number is calulated and it is less than 150, display 150, or display the calulated number (where it is 150 to 500). When the result in L20 is the custom error message, and I use this in cell D20, =IF(L20500,500,IF(L20<150,150,L20)) excel displays 500, not the error text/message result from cell L20 Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF(logical_test, may be a number or text
Hi,
=IF(ISTEXT(L20),L20,IF(L20500,500,IF(L20<150,150, L20))) Mike "workworkwork" wrote: The calculated value in cell L20 may be a number or a customized error string/text message. In cell D20 I need to display the text in in L20 if that is the result, or if a number is calculated and number calculated is greater than 500, display 500, of if a number is calulated and it is less than 150, display 150, or display the calulated number (where it is 150 to 500). When the result in L20 is the custom error message, and I use this in cell D20, =IF(L20500,500,IF(L20<150,150,L20)) excel displays 500, not the error text/message result from cell L20 Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF(logical_test, may be a number or text
Thank you!
"Mike H" wrote: Hi, =IF(ISTEXT(L20),L20,IF(L20500,500,IF(L20<150,150, L20))) Mike "workworkwork" wrote: The calculated value in cell L20 may be a number or a customized error string/text message. In cell D20 I need to display the text in in L20 if that is the result, or if a number is calculated and number calculated is greater than 500, display 500, of if a number is calulated and it is less than 150, display 150, or display the calulated number (where it is 150 to 500). When the result in L20 is the custom error message, and I use this in cell D20, =IF(L20500,500,IF(L20<150,150,L20)) excel displays 500, not the error text/message result from cell L20 Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF(logical_test, may be a number or text
On Oct 28, 4:50*pm, workworkwork
wrote: The calculated value in cell L20 may be a number or a customized error string/text message. In cell D20 I need to display the text in in L20 if that is the result, or if a number is calculated and number calculated is greater than 500, display 500, of if a number is calulated and it is less than 150, display 150, or display the calulated number (where it is 150 to 500). When the result in L20 is the custom error message, and I use this in cell D20, =IF(L20500,500,IF(L20<150,150,L20)) excel displays 500, not the error text/message result from cell L20 Thank you I just sitting here waiting for an answer myself. What about using ISNUMBER see IS Functions |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF(logical_test, may be a number or text
Any text is deemed to be greater than any number.....so when L20 is
text it satisfies the first condition and 500 is returned. Best to use an IF to check if L20 is a number or not =IF(ISNUMBER(L20),MEDIAN(0,500,L20),L20) regards, barry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i write logical_test for more than 100 values (IF) | Excel Discussion (Misc queries) | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
| Can't find logical_test for "if"statement | Excel Worksheet Functions | |||
Hybrid Mode
