Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
an if question
hey guy's A1 = 500-400, but if A1 equals a negative then i need A1 to equal 0. please help. thanks, jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=521982 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
an if question
Try this: A1: =MAX(500-400,0) Does that give you something to work with? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=521982 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
an if question
There's no formula which would set A1 to 0 if it was negative. You could do this
with a macro, but I doubt you need to go to this much trouble. Your likely best bets a 1. If there currently is a formula in A1, then change it to an IF statement, as in: =if(b1-c1<0,0,b1-c1) 2. If you have other formulas referring to A1, have them test for a negative value first. -- Regards, Fred "jwfakouri" wrote in message ... hey guy's A1 = 500-400, but if A1 equals a negative then i need A1 to equal 0. please help. thanks, jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=521982 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
an if question
=MAX(500-400,0)
-- tj "jwfakouri" wrote: hey guy's A1 = 500-400, but if A1 equals a negative then i need A1 to equal 0. please help. thanks, jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=521982 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding and deleting question marks | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |