#Div/0
"H" wrote:
is there a way to do something like this for - I'm getting the
#Div/0 on a few cuz T is 0
=+(X2/T2)*12
=if(T2=0, "", 12*X2/T2)
That results in a cell that appears blank if T2 is zero. Alternatively,
replace "" with anything else you wish, for example 0.
|