+ Reply to Thread
Results 1 to 2 of 2

IF Function Problems with Excel 2007 - Help!

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation IF Function Problems with Excel 2007 - Help!

    Hello! I'm new to this forum, but I need your help. I'm adding functions to a spreadsheet for work, but I am running into some errors. Basically, I need the functions to do the following.

    1) If E5 is blank or 0, F5 needs to say $0.00.
    2) If E5 is <6 but >0, F5 needs to say $450.00.
    3) If E5 is >=6, F5 needs to say $900.00.
    4) All of the results from the F column need to be calculated into a total dollar amount, i.e. $1,800.00.

    I've gotten functions two and three to work with the IF Function (see below). However, it always says $450.00 when the cell is blank or is at 0.

    =IF(IF(E5<6,AND(E5>0)),"$450.00","$900.00")

    Also, when trying to use the SUM function on the values in column F, it says 0. I believe that is because the IF Function produces text values instead of numbers.

    How can I fix these errors? Thanks so much for your help!

    Lesley

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: IF Function Problems with Excel 2007 - Help!

    From your steps posted above (1-3), I would use this...

    =IF(OR(E5={"",0}),0,IF(E5<6,450,IF(E5>=6,900,"")))

    and format the cell as currency
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1