LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
smdettloff
 
Posts: n/a
Default Problem with IF function/circular/HELP!


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
driving me nuts! Here it is:

I want (cells not named so I'm using cell id's): D5-G5. If the result
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 (in
other words a positive number), then I want the field to give the
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 got
a circular error?

PLEASE HELP!


--
smdettloff
------------------------------------------------------------------------
smdettloff's Profile: http://www.excelforum.com/member.php...o&userid=26839
View this thread: http://www.excelforum.com/showthread...hreadid=400846

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
Slight problem automating Excel in a service someone Setting up and Configuration of Excel 2 May 13th 05 10:04 PM
Excel Display Problem Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 0 April 19th 05 05:25 PM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 05:33 PM


All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"