Results 1 to 5 of 5

This formula is too advanced for me.

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2011
    Location
    Florida, USA
    MS-Off Ver
    Excel 2007
    Posts
    7

    This formula is too advanced for me.

    This formula is too advanced for me.

    The number series that will appear in Cell A1 are listed below:

    4.0 thru 4.999999999, 5.0 thru 5.999999999, 6.0 thru 6.999999999, 7.0 thru 7.999999999, 8.0 thru 8.999999999, 9.0 thru 9.999999999, 10.0 thru 10.999999999, 11.0 thru 11.999999999, 12.0 thru 12.999999999.

    I am trying to develop a formula for Cell B1 that will resolve the problem:

    Each one of these nine series of numbers above, will have its own multiplier.
    Note: The multiplier value will be assigned simply by adjusting the formula.

    Example:
    4.0 thru 4.999999999 X $5.00, 5.0 thru 5.999999999 X $13.00, 6.0 thru 6.999999999 X $15.00, – Etc. up to: 12.0 thru 12.999999999 X $25.00

    Any help would be greatly appreciated.
    Thanks
    Last edited by okenter; 07-02-2011 at 10:43 PM.

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