how do i enter a formula in excel that will change a cell value
 

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(G40,))) 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

how do i enter a formula in excel that will change a cell value
 

Are you looking for this?

=IF(G4<0,0)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jace35" wrote:

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(G40,))) 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

how do i enter a formula in excel that will change a cell valu
 

I used that formula first which works if the figure is 0 or less but I also
want it to leave the value in the cell if it is greater than 0 but it is not
doing that!

Thank you for your reply by the way!

"Ron Coderre" wrote:

Are you looking for this?

=IF(G4<0,0)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jace35" wrote:

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(G40,))) 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

how do i enter a formula in excel that will change a cell value
 

Try the following.
=IF(G4<0,0,G4)

"Jace35" wrote:

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(G40,))) 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

how do i enter a formula in excel that will change a cell valu
 

That works perfectly - thank you very much!!

"William Horton" wrote:

Try the following.
=IF(G4<0,0,G4)

"Jace35" wrote:

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(G40,))) 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