Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
If function with text
I posted a question about if function earlier, but here is the a new twist.
I want to use a function probably the if function to check if say from cell A2 to E1 to see if the value is less than .5 or no data or equal to o, if true than give cell F1 a value of 1, and if cell A1 has not text in it, then, give cell F1 a blank or nothing. How do I write this function? |
#2
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
If function with text
try
=IF(ISTEXT(a1),"","Nottext") -- Don Guillett SalesAid Software "Richard" wrote in message . .. I posted a question about if function earlier, but here is the a new twist. I want to use a function probably the if function to check if say from cell A2 to E1 to see if the value is less than .5 or no data or equal to o, if true than give cell F1 a value of 1, and if cell A1 has not text in it, then, give cell F1 a blank or nothing. How do I write this function? |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
If function with text
Try =if(and(citeria 1," ",criteria 2," ",0))
"Richard" wrote: I posted a question about if function earlier, but here is the a new twist. I want to use a function probably the if function to check if say from cell A2 to E1 to see if the value is less than .5 or no data or equal to o, if true than give cell F1 a value of 1, and if cell A1 has not text in it, then, give cell F1 a blank or nothing. How do I write this function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
Advanced text function (combining text) | Excel Worksheet Functions | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |