| 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA | Excel Worksheet Functions | |||
| Countif function for instances of text string contained | Excel Worksheet Functions | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| How can I combine text and a function in a single cell | Excel Worksheet Functions | |||
| How do I add help text to an excel function I have created | Excel Worksheet Functions | |||
Threaded Mode
