Formula help in excel 2007
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
Computer:
Windows XP Professional
Asus A8N-VM Socket 939 Motherboard with NForce 410
AMD Athlon 64 3500+ 2.45ghz-Venice Core
2x1024MB PC3200 Kingston Ram in Dual Channel
ATI Radeon X800XL 256MB GDDR3,16 Pipelines overclocked to 442mhz/1080mhz
Enermax 420W "Silent" Powersupply
Bookmarks