Results 1 to 11 of 11

Excel 2007 : Multi-variable values, conditions

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Multi-variable values, conditions

    Hi guys!

    Could you tell me the proper formatting for multiple conditions:

    In cell A1 I want to type in values; I want cell B1 to generate a corresponding figure.

    For example:

    If A1=0 then I want B1 to show 50; if A1=0.1, I want B1 to show 51.6; if A1=0.2, I want B1 to show 53.2, etc.

    Thanks in advance! Sorry about the lack of proper terminology!
    Last edited by tornado25; 06-24-2012 at 05:30 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1