I want a cell to show ---- when empty

December 8, 2011 at 15:53:46
Specs: Windows 7
excel 2010 how do i make a cell read ----when the cell is empty, I need to add the error function to this formula=IF(H14="ID","No Cost",IF(H14="OR","No Cost",IF(H14="NV",O28*6%,O28*9%)))

See More: I want a cell to show ---- when empty

Report •

#1
December 8, 2011 at 16:37:30
Your question makes no sense.

re: "how do i make a cell read ----when the cell is empty"

If the cell has ---- in it then it is not empty.

re: "I need to add the error function to this formula..."

What error function?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question