I have a cell which gives me the correct result if i enter a 1 or 2, however i cant get it to be blank if the cell is empty or zero.
I think it is an if statement but i cant seem to get it to work.
Can anyone advise please?
Thank you
I have a cell which gives me the correct result if i enter a 1 or 2, however i cant get it to be blank if the cell is empty or zero.
I think it is an if statement but i cant seem to get it to work.
Can anyone advise please?
Thank you
Last edited by gjjh25; 11-24-2011 at 07:14 AM.
I think you in U6 should write =if(s6=0;" "; N6&" "&P6&" "&Q6&" "&T6)
maybe
=IF(S6=0,"",N6&" "&P6&" "&Q6&" "&T6)
Thank you both that has worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks