Question about Microsoft Excel for PC
Add an IF statement that encloses the formula you've already written. Assuming the result is in one cell, called CELLREF for purposes of writing this for you:
=If(CELLREF>0,CELLREF,(------INSERT YOUR FORMULA ABOVE------),0)
Thank you for rating FixYa!
Posted on Apr 24, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 13, 2015 | Microsoft Excel for PC
Mar 06, 2015 | Microsoft Excel 2010
Oct 17, 2013 | 1996 Italdesign Formula
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Jun 06, 2010 | Microsoft Excel for PC
Dec 29, 2008 | Microsoft Office 2003 Basic Edition...
Aug 25, 2008 | Microsoft Office Professional 2007:...
Aug 08, 2008 | Microsoft Computers & Internet
Jul 08, 2008 | Microsoft Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
227 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: