LinkBack URL
About LinkBacks
test1.png
Question:
1) What kind of formula that to be add if I want column 4 return value "0" when Column 1 is blank as per scenario 1?
2) What kind of formula that to be add if I also want Column 2 leave it empty when Column 1 is no figure?
test1.png
Question:
1) What kind of formula that to be add if I want column 4 return value "0" when Column 1 is blank as per scenario 1?
2) What kind of formula that to be add if I also want Column 2 leave it empty when Column 1 is no figure?
Last edited by ulala2; 02-25-2017 at 10:23 AM.
Just for future reference, columns are known by the letter at the top of the column A, B, C D etc, and rows are known by the number to the very left of the row 1, 2, 3, 4 etc
Having said that, if you want a cell to show nothing until another cell has data entered into it...
=IF(A2="","",your-formula)
Does that help?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This solved Question 2. How about Question 1??Originally Posted by FDibbins
Just for future reference, columns are known by the letter at the top of the column A, B, C D etc, and rows are known by the number to the very left of the row 1, 2, 3, 4 etc
Having said that, if you want a cell to show nothing until another cell has data entered into it...
=IF(A2="","",your-formula)
Does that help?
Thank you.
Last edited by ulala2; 02-25-2017 at 10:24 AM.
=if(a2="","",a2+14)
Pretty much the same thing (as John showed)
oops....just found out there are some typo error.
the formula of
if(a2="","".a2+14) solved question 2.
Question 1, if A8 is without any value, D8 will return value of 42790.
if i want D8 return value as "0" when A8 is blank, what formula should i add?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks