 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2005Problem with IF function/circular/HELP!
What I want to do seems so simple but it's the only formula on thi spreedsheet I can't figure out. I've spent all day on it and it' driving me nuts! Here it is: I want (cells not named so I'm using cell id's): D5-G5. If the resul is less than or equal to 0 (in other words, if it's a negative number) then I want the field to say 0. If the answer is greater than 0 (i other words a positive number), then I want the field to give th result of D5-G5. (the cell where the result is in is H5) I've tried it a few different ways and it never works out. Once I go a circular error? PLEASE HELP smdettloff -- How about =max(0,d5-g5) > What I want to do seems so simple but it's the only formula on this > spreedsheet I can't figure out. I've spent all day on it and it's [quoted text clipped - 10 lines] > > PLEASE HELP! Type this in H5: IF(D5-G5<0,0,D5-G5)  SignatureCutter Unfortunately it's still not working. I put the formula in H5 and pu small numbers in D5 and G5 just to test it but I'm getting a result o 0 when I should be getting 5.00. I've tried to attach a screen shot +------------------------------------------------------------------- |Filename: CaptureWiz007.jpg |Download: http://www.excelforum.com/attachment.php?postid=3769 +------------------------------------------------------------------- If D5 is smaller then G5, then you should get a zero, Which is *exactly* what you got. Your formula is working correctly! You just have to get your mind around your own formula. =If(D5-G5<0,0,D5-G5) D5 = 5 G5 = 10 5 - 10 = -5 Which is *less* then 0 Makes the first argument TRUE, so the return is 0. SignatureHTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== > Unfortunately it's still not working. I put the formula in H5 and put > small numbers in D5 and G5 just to test it but I'm getting a result of [quoted text clipped - 4 lines] > |Download: http://www.excelforum.com/attachment.php?postid=3769 | > +-------------------------------------------------------------------+ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.