|
| |||||||||
| Tags: 2007, excel, formula, help |
Sponsored Links
Formula help in excel 2007
Windows Software
 |
| | Thread Tools | Search this Thread |
|
| |||||||||
| Tags: 2007, excel, formula, help |
|
| | Thread Tools | Search this Thread |
|
#1
24-11-2008
| ||||
| ||||
| 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  |
|
|
| Thread Tools | Search this Thread |
| |
Similar Threads for: "Formula help in excel 2007" | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Formula | Richard Schwager | MS Office Support | 3 | 15-02-2011 02:21 PM |
| Copy paste formula automatically in Excel 2007 | Macadrian | Software Development | 3 | 12-11-2009 08:19 PM |
| Excel formula | Me Me Taylor | Windows Software | 2 | 06-04-2009 05:11 PM |
| Formula Problem in Excel 2007 | hariharan_00 | Windows Software | 2 | 07-01-2009 09:33 PM |
| Need help in excel formula | Landon | Software Development | 2 | 27-10-2008 04:28 PM |
