excel - Find the difference between two cells -
below example of excel sheet. in want find gain , loss using e , d cells. if e>d should calculate e-d , value should entered in f cell , if e
enter formula cell f2
:
=if(e2 > d2, e2 - d2, "-")
then enter formula cell g2
:
=if(e2 <= d2, e2 - d2, "-")
for row not gain or loss, -
dash appear in column.
Comments
Post a Comment