+ Reply to Thread
Results 1 to 3 of 3

If isnumber combined with then formula?

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2013
    Posts
    27

    If isnumber combined with then formula?

    Hi All,
    I am trying to do a nested If statement combined with a formula.
    I have some invoices that bill me monthly and some quarterly. Monthly bills go in column B and Quarterly in column C. In column F I want to just know the Quarterly cost.
    So essentially, if C is a number, then just return that number, all done. But if it's blank, then look into B and take that number and multiply it by 3 (months) to get a Quarterly total.

    I tried something like this
    =IF(AND(ISNUMBER(B3), ISNUMBER(C3)), B3, C3)

    which returns the quarterly columns properly but then gives me zeros for the monthly, and I am aware I have not added in the *3 component either.

    Any help appreciated!

  2. #2
    Registered User
    Join Date
    08-21-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2013
    Posts
    27

    Re: If isnumber combined with then formula?

    Maybe getting closer with this idea...need help converting the IF FALSE piece into a working formula.)

    =IF(ISNUMBER(C3), C3, "Multiply B3 by 3")
    bloombergexample.jpg

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2013
    Posts
    27

    Re: If isnumber combined with then formula?

    Nevermind! Got it to work! SOLVED!

    HTML Code: 

+ 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