hello , i need help using "IF" formula in excel 2007.
can someone guide me with the following formula
=IF(F4<24, F4*8.7,F4*7/2) goes to f4*7/2 if 24 else multipliesf4*8
can i express more than one figure like the one above which calculates a different sum if the criteria 24 is met,can there be multiples to perform different calculations with more figures like 24as an example
thanks
