+ Reply to Thread
Results 1 to 2 of 2

Number in cell X equal number in cell Y

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Toulouse
    MS-Off Ver
    Excel 2010
    Posts
    141

    Number in cell X equal number in cell Y

    Hey guys,

    Please I want to write a formula that state

    if cell A equal to 1 then The Number in cell B must be the cell in cell C
    lets say A=1 then if B=50 this 50 must be shown in C

    If(A=1; B=C)

    it is not working
    could please help

    Thanks

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Number in cell X equal number in cell Y

    In Cell C, put the formula

    =IF(A2=1,B2,"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I get a letter in one cell ito equal a number in anotherl..
    By Dave Cadey in forum Excel General
    Replies: 7
    Last Post: 09-12-2014, 03:46 PM
  2. [SOLVED] increase number if cell directly above is equal
    By jschober in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-02-2012, 09:40 AM
  3. sumif non-number not equal to cell X
    By c_george in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2007, 04:44 PM
  4. [SOLVED] Cell can only equal Whole Number
    By TriFiV in forum Excel General
    Replies: 2
    Last Post: 06-18-2006, 05:00 PM
  5. Replies: 7
    Last Post: 01-15-2005, 01:06 AM

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