Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Calculate Formula Only If Cell Contains a Number

1. Member
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. Established Member
Join Date
25th April 2006
Posts
973

## 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. ## Re: Calculating Formulas Only If...

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

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

#### 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