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

Posted to microsoft.public.excel.worksheet.functions

Jace35

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible?	DakotaNJ	Excel Worksheet Functions	25	September 18th 06 09:30 PM
Custom functions calculating time arguments Help Desperate	Bill_De	Excel Worksheet Functions	12	April 25th 06 02:22 AM
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?	C-Man23	Excel Worksheet Functions	1	January 9th 06 01:23 PM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
How to change a formula in one cell and have these changes appear	Duke Carey	Excel Worksheet Functions	1	May 17th 05 06:15 PM

All times are GMT +1. The time now is 11:00 PM.

Menu

About Us