Results 1 to 3 of 3

Thread: Excel Help

  1. #1
    Senior Member Blackmage's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    1,934
    Thanks
    202
    Thanked
    65 times in 45 posts
    • Blackmage's system
      • Motherboard:
      • MSI P67-GD65
      • CPU:
      • Intel Core I7 2600k
      • Memory:
      • 8 Gb Hynix DDR3 1333
      • Storage:
      • Crucial m4 120Gb, 2TB Samsung F4
      • Graphics card(s):
      • ATI HD5830
      • PSU:
      • 700w Coolermaster Gold Plus
      • Case:
      • Xclio/Aplus Windtunnel
      • Operating System:
      • Windows 7 Professional
      • Monitor(s):
      • Viewsonic VX2239WM 22" LCD Monitor
      • Internet:
      • Virgin Broadband 10mbit

    Excel Help

    Hey, i no really basic of excel like Count,sum etc. i got some values that i would like too have a variable using an IF statement. for example IF The total cost of the products are greater the 6000 subtract a 10% discount.

    this is what i had come up with

    =IF (D26=>6000-10%)
    is this near right?

  2. #2
    Member
    Join Date
    Feb 2006
    Location
    Lake District
    Posts
    69
    Thanks
    0
    Thanked
    0 times in 0 posts
    • Lakeuk's system
      • Motherboard:
      • Gigabyte P965-DS4
      • CPU:
      • Core 2 Duo E6600
      • Memory:
      • 2Gb standard spec
      • Storage:
      • 2 x 250Gb, 1 x 160Gb plus external 320Gb for backups
      • Graphics card(s):
      • fanless 7600GS
      • PSU:
      • 450watt standard came with case
      • Case:
      • Antec Sonata II
      • Monitor(s):
      • Samsung 940BF - 19" 2ms
      • Internet:
      • Demon 8Mb
    Close

    =IF(A1>=6000,A1-(A1*10%),A1)

  3. #3
    Senior Member Blackmage's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    1,934
    Thanks
    202
    Thanked
    65 times in 45 posts
    • Blackmage's system
      • Motherboard:
      • MSI P67-GD65
      • CPU:
      • Intel Core I7 2600k
      • Memory:
      • 8 Gb Hynix DDR3 1333
      • Storage:
      • Crucial m4 120Gb, 2TB Samsung F4
      • Graphics card(s):
      • ATI HD5830
      • PSU:
      • 700w Coolermaster Gold Plus
      • Case:
      • Xclio/Aplus Windtunnel
      • Operating System:
      • Windows 7 Professional
      • Monitor(s):
      • Viewsonic VX2239WM 22" LCD Monitor
      • Internet:
      • Virgin Broadband 10mbit
    thanks im going to try it give you feed back later.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel windows
    By Steve in forum Software
    Replies: 4
    Last Post: 25-07-2006, 12:44 PM
  2. M$ Excel masters..
    By XA04 in forum Help! Quick Relief From Tech Headaches
    Replies: 9
    Last Post: 19-09-2005, 10:48 AM
  3. Replies: 6
    Last Post: 12-08-2005, 08:50 AM
  4. Excel spreadsheet fixing tool?
    By joshwa in forum Software
    Replies: 2
    Last Post: 28-10-2004, 11:23 AM
  5. Excel - Office XP
    By KDH in forum Software
    Replies: 0
    Last Post: 04-08-2004, 11:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •