Home › Questions › Excel help needed?
I am trying to get cell I2 to have the value of cell E2 if H2 is at a zero total, but if H2 has any value in it, I want I2 to be zero.
=if(h2=0,e2,0)This is equivalent to the statement "if(h2 = 0) then cell <- e2, else cell <- 0".I don't know what "zero total" means.
that did the trick thank you
You must sign in to view your friends.
that did the trick thank you