I have the following formula:
=IF(R11>0,Q13,"")
The cell R11 is blank so I want it to be equivalent to 0 aka zero so that the cell Q13 will be blank. However, R11 has a formula in there even though it appears blank so it keeps making my current cell equal to the value in Q13. But I want that current cell to be blank since R11 realistically is blank (just has formula)
what is the formula in R11?
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
=IF(R11>0,Q13,0) ?
not clear with your criteria....
Azumi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks