Hi
Can someone let me know how I can leave a result cell empty unless there is data in the cells that the formula points to.
eg =(A1*A2-A3) If this formula is in cell A4 and I want to copy down but have no data in the cells below. What will the formula be? ie to have no zero in the empty cell.
I know it's an IF formula but ???
Thanks
Chris
=if(A1="","",<formula>)
extended for multiple precedents:
=if(or(A1="",A2="",A3=""),"",<formula>)
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Thanks Charlie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks