+ Reply to Thread
Results 1 to 3 of 3

Easy formula needed

  1. #1
    Registered User
    Join Date
    03-04-2005
    Posts
    2

    Easy formula needed

    i am trying to figure out how to make a formula multiply a cell by 2 if a certain cell has a y in it and multiply it by 1 if that cell has a n in it.. let me try ex:

    cell A=4 cell B has a "y" then cell C would be cell A*2 or if cell A=4 cell B has a "n" then cell C would be cell A*1..

    so if there was a y cell b then c would be 8 and if there was a n in cell b then cell c would be 4 ....

    hope that makes since

    please forgive my ignorance

  2. #2
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    =if(B1="y",A1*2,if(B1="n",A1*1,0))

  3. #3
    Registered User
    Join Date
    03-04-2005
    Posts
    2
    Works Perfect.. Thank You very much

+ Reply to Thread

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