LinkBack URL
About LinkBacks
I want my formula to output a blank cell if the answer is 0.
Ex. [B1=IF(A1=0, ???, A1)] . I want B1 = A1 if A1 is not 0. I want B1 to output a blank cell if A1 = 0.
I want my formula to output a blank cell if the answer is 0.
Ex. [B1=IF(A1=0, ???, A1)] . I want B1 = A1 if A1 is not 0. I want B1 to output a blank cell if A1 = 0.
Last edited by greggga; 03-20-2009 at 10:16 AM.
=if(a1=0;"";a1)
Never use Merged Cells in Excel
Thank you.
Please, edit thread and put it Closed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks