Results 1 to 13 of 13

IF function issue

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Boca Raton, FL
    MS-Off Ver
    Excel 2010
    Posts
    11

    IF function issue

    Hello all,
    I'm new to excel and have been teaching myself slowly to help with some tasks I'm faced with at work.

    I'm working on a table right now.
    Column A has different types of carriers (A1=broadcast, A2=government, A3=Data, etc)
    Column B is where i'd like to put the $ amount of rent that each different type of carrier pays

    I tried =If(A1="broadcast", 350) ...and that works, but how do I create a formula where if A1= broadcast B1 will equal $350 or if A1=government then B1=250

    I tried =IF(OR(F2="broadcast",350),OR(F2="government",250)) but it keeps returning TRUE.

    I also tried doing =IF(or(and....but that didn't work either.

    can anyone fix my formula and also explain why it works that way and not how I'm doing it?

    thank you so much!!
    Last edited by mbeyatli; 03-04-2014 at 11:31 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  2. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  3. [SOLVED] Using Offset function as the array in the PercentRank function is giving wrong result
    By Bobneil in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 09:29 PM
  4. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  5. Replies: 2
    Last Post: 03-20-2009, 01:29 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