Question about Microsoft Excel for PC
I am using this function for Cell E6:
It works great but if B6 is blank it returns an erroneous negative number for E6 since it assumes B6=0.
How can I modify the formula to force a blank E6 if B6 is bank?
You can use an IF statement:
In your case, this would be:
This works as follows:
IF(B6<>"", : If B6 is not equal to nothing, ie. it equals something
SUM((B6+D6)-(B5+C6)), : Set the value as per the equation
"") : Otherwise set the value to nothing.
Of course, this only checks that there is a value in B6. Depending on that value (and that of the other cells) you could still get a negative result. The way to avoid this would be to use the following:
A bit long winded, but basically it checks the result of the sum is greater than 0. If it is it displays it, if not it leaves the cell blank.
Hope this helps,
Posted on Mar 03, 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:
Jun 09, 2010 | Microsoft Office Professional 2007 Full...
Apr 02, 2008 | Computers & Internet
Sep 20, 2009 | StarTech.com StarView SV211K 2-port KVM...
Jan 10, 2009 | Microsoft Office Standard for PC
Dec 16, 2008 | StarTech.com StarView SV211K 2-port KVM...
Mar 07, 2008 | Microsoft Excel for PC
Feb 29, 2008 | Microsoft Excel for PC
Dec 09, 2007 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
142 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: