Waht formula i should use

F

Filipe Cunha

I have 3 excel sheets, CBL 1 and CBL 2, and the last is Total CBL.
What I want to do is sum de same cell of CBL1 and CBL2 (for example D12) in
the TOTAL CBL, teh resul shoul appear on the D12 cell on the Total CBL sheet.
The problem is if the value is equals to zero, i dont want to see any
result, I want to have a blank cell.
 
M

Max

One way is to suppress extraneous zeros from displaying
in the TOTAL CBL sheet via:
Tools > Options > View tab > Uncheck Zero values > OK
 
F

Filipe Cunha

Thank you very much

you have solved my problem, in a very simple way

"Max" escreveu:
 
Top