Results 1 to 5 of 5

Formula to change number from one cell to other cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Formula to change number from one cell to other cell

    Hi I have tried make a formula for below criteria, and even i actually have got some help before similar( Not same)
    I cant make it work. I am not that good to formulas.
    This is the criteria.
    All in sheet 1.

    If cell O6 minus 50 type 0 in cell O8
    If cell O6 is same or bigger than 50 type 25 in cell O8
    If cell O6 is same or bigger than 80 type 50 in cell O8
    If cell O6 is same or bigger than 90 type 75 in cell O8
    If cell O6 is same or bigger than 100 type 100 in cell O8

    I have made a table and tried with that. Its in cell x1 all can be seen in the below test sheet.
    The table i have in the test sheet is named table2. In the real workbook i already have other table named table1
    Try have a look at below test sheet.
    Will be great if some can help with it.
    Thanks in advance
    Sincerely
    Abjac
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] when I change cell number formula fails to work
    By scudo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2016, 06:28 PM
  2. Replies: 5
    Last Post: 01-15-2016, 06:16 PM
  3. [SOLVED] Change one number in a cell inside a formula to a variable that is getting higher (+1)
    By chablo309 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2015, 07:28 AM
  4. Replies: 5
    Last Post: 12-03-2014, 05:02 PM
  5. [SOLVED] Multi Formula Cell Number Change Problem
    By JUDSON_IRELAND in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 05-08-2014, 11:21 AM
  6. Replies: 3
    Last Post: 09-14-2012, 04:32 AM
  7. Replies: 2
    Last Post: 10-22-2005, 07:05 PM

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