example A1="" B1=2 C1=3 IN F1: =A1-(B1/10)-(C1/10)
answer should be -.01
Need to skip which ever cell of the three is blank and only do the next part of the calculation
So the A1- part is skipped in the calculation because A1 is blank (in the example). But any cell of the 3 could be blank.
Last edited by JJGF; 11-17-2013 at 05:49 PM.
Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Doesn't work, results in -.05 instead of -.01 due to the 0 replacing the blank cell in A1Originally Posted by mehmetcik
Please Login or Register to view this content.
Seems to work according to example I provided, now what if 2 of 3 cells are blank, if not too much trouble, how would you modify this formula?Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks