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.