Results 1 to 2 of 2

Thread: If Formula

  1. 2012-10-29, 05:03 PM #1
    Shazz
    Shazz is offline
    Seeker Shazz's Avatar
    Join Date
    May 2012
    Posts
    15
    Articles
    0

    If Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I have a spreadsheet were I want to have N1 have "CB" in it if K1 says "Jerry Warwick"

    Can anyone help me please.

    Shazz
    Reply With Quote Reply With Quote
  2. 2012-10-30, 09:31 AM #2
    Kevin@Radstock
    Kevin@Radstock is offline
    Acolyte Kevin@Radstock's Avatar
    Join Date
    Oct 2012
    Posts
    52
    Articles
    0
    Excel Version
    365
    May be!

    =IF(K1="Jerry Warwick","CB","")
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules

Gravatar by 1e2.it