+ Reply to Thread
Results 1 to 3 of 3

Excel 2003 How to Add to the IF formula

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    New Brunswick, NJ
    MS-Off Ver
    Excel 2003
    Posts
    53

    Excel 2003 How to Add to the IF formula

    I have an If formula that calculates a rating:

    {=IF($C3="2011-01","",IF(F3<-0.115,-1,IF(F3>0.115,1,0)))}

    I want to add {IF(F3="",G3="",IF(F3<-0.115,-1,IF(F3>0.115,1,0)))} in between the 1st IF and 2nd IF.

    Or in words if the F column is blank I want the rating in the G column to be blank and not turn out 0 like it is doing.

    I attached an example to make it easy to see, I feel like the formula I wrote to add in should work but it does not, any help you can give me I would greatly appreciate many thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor CheshireCat's Avatar
    Join Date
    10-11-2011
    Location
    Victoria, Canada
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    258

    Re: Excel 2003 How to Add to the IF formula

    Try this:

    Please Login or Register  to view this content.
    Docendo discimus.

  3. #3
    Registered User
    Join Date
    06-22-2012
    Location
    New Brunswick, NJ
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Excel 2003 How to Add to the IF formula

    Thank you very much works great! Sorry not letting me boost rep again but your help is much appreciated.

+ 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