G
Guest
I want to enter a formula that will change that will allow be to change the
value of a cell to 0 if the sum is les sthan 0 or a minus figure if it is a
plus figure then I want it to stay the same. I have used a formula of:
=(IF(G4<0,0*(IF(G4>0,))) this will change the cell value to 0 if it is a
minus figure but just enters the word FALSE if it is greater than 0
value of a cell to 0 if the sum is les sthan 0 or a minus figure if it is a
plus figure then I want it to stay the same. I have used a formula of:
=(IF(G4<0,0*(IF(G4>0,))) this will change the cell value to 0 if it is a
minus figure but just enters the word FALSE if it is greater than 0