Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function help Please
I was hoping I could get some help with writing an excel function
generally I would like to know how to use IF THEN functions. Like if the sum of a data range is Less than a certain value then execute equation A, else if the sum of a data range is greater than a certain value then execute equation B. Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function help Please
Meg,
The general syntax for a IF() function is: =IF(Test, Do if Test is True, Do If Test is False) The Do if Test True and Do if Test False parts can be any legal Excel statement including anothe IF() function. In your example the test would be SUM(A1:A10)100 The answer to which will either be TRUE or FALSE, so the whole function will be: =IF(SUM(A1:A10)10,COUNTIF(B1:B100,"Meg"),AVERAGE( C1:C500)) -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Meg" wrote in message ups.com... I was hoping I could get some help with writing an excel function generally I would like to know how to use IF THEN functions. Like if the sum of a data range is Less than a certain value then execute equation A, else if the sum of a data range is greater than a certain value then execute equation B. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |