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
I want to use a function probably the if function to check if say from cell
A1 to E1 to see if the value is less than .5 or no data, if true than give cell F1 a value of 1. 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
Hi Richard
Do you want to test if every cell in A1:E1 is less than .5 or not have data Try this in F1 =IF(MAX(A1:E1)<0.5,1,"") -- Regards Ron de Bruin http://www.rondebruin.nl "Richard" wrote in message ... I want to use a function probably the if function to check if say from cell A1 to E1 to see if the value is less than .5 or no data, if true than give cell F1 a value of 1. How do I write this function? |
#3
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
if function
=if(A1<.5,1,"")
if you are looking for all values to be less than .5 or blank =if(sum(countif(A1:E1,{"<.5",""}))=5,1,"") -- Regards, Tom Ogilvy "Richard" wrote in message ... I want to use a function probably the if function to check if say from cell A1 to E1 to see if the value is less than .5 or no data, if true than give cell F1 a value of 1. How do I write this function? |
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 | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |