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 expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (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
136 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: