Excel function help Please

[Meg]

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.

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk