Results 1 to 2 of 2

Thread: Formula help in excel 2007

  1. #1
    Join Date
    Aug 2006
    Posts
    93

    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

  2. #2
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Formula help in excel 2007

    hi try this code
    =IF(F4<24,F4*8.7,IF(F4=24,F4*7/2,F4*8))

Similar Threads

  1. Replies: 2
    Last Post: 28-04-2012, 07:17 AM
  2. How to accept label under formula option in Microsoft Excel 2007
    By Mathrubootham in forum MS Office Support
    Replies: 2
    Last Post: 16-02-2012, 08:02 PM
  3. Copy paste formula automatically in Excel 2007
    By Macadrian in forum Software Development
    Replies: 3
    Last Post: 12-11-2009, 08:19 PM
  4. Excel formula
    By Me Me Taylor in forum Windows Software
    Replies: 2
    Last Post: 06-04-2009, 04:11 PM
  5. Formula Problem in Excel 2007
    By hariharan_00 in forum Windows Software
    Replies: 2
    Last Post: 07-01-2009, 09:33 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,715,958.41980 seconds with 17 queries