| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| How to change a formula in one cell and have these changes appear | Excel Worksheet Functions | |||
Hybrid Mode
