Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Calculate Formula Only If Cell Contains a Number

  1. #1
    Join Date
    29th July 2006
    Posts
    22

    Calculate Formula Only If Cell Contains a Number

    Thanks all for the help. I would like a cell D19 to calculate a formula ONLY if cell C19 produces a number, otherwise I would like it to remain clear. I would like cell D19's formula to calculate =C19*D11. How can I do this?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th April 2006
    Posts
    890

    Re: Calculating Formulas Only If...

    In D19 enter this

    =IF(C19<>"",C19*D11,"")

    alternatively


    =IF(C19="","",C19*D11)
    Last edited by bryce; September 15th, 2006 at 09:43.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,698

    Re: Calculating Formulas Only If...

    =if(isnumber(c19),c19*d11,"")

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Formula: Calculate Based on Cell Value
    By exceldummie in forum EXCEL HELP
    Replies: 3
    Last Post: October 21st, 2006, 22:46
  2. Formula: Find Number in Range & Calculate If Found
    By RicoSimp in forum EXCEL HELP
    Replies: 4
    Last Post: October 10th, 2006, 17:45
  3. Calculate X Number Of Rows In Range Based On Cell Value
    By bobwhosmiles in forum EXCEL HELP
    Replies: 3
    Last Post: October 3rd, 2006, 00:12
  4. Calculate Formula Based on Cell Criteria
    By cnl in forum EXCEL HELP
    Replies: 3
    Last Post: August 31st, 2006, 12:48
  5. Replies: 8
    Last Post: May 31st, 2006, 11:21

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
  •  
porno