Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bruce2444
 
Posts: n/a
Default Formula which is greater tahn or equal to zero

I am trying to create a formula which when calculated, if the result is equal
to or less than zero, the result would be zero, otherwise calculation would
give proper answer.

Example: Formula for i2
=j2-h2

If answer was equal to or less than zero, result would equal zero (not a
negative) otherwise calculate j2-h2

  #2   Report Post  
Rowan
 
Posts: n/a
Default

Hi Bruce

Try =IF(J2-H20,J2-H2,0)

Regards
Rowan

bruce2444 wrote:
I am trying to create a formula which when calculated, if the result is equal
to or less than zero, the result would be zero, otherwise calculation would
give proper answer.

Example: Formula for i2
=j2-h2

If answer was equal to or less than zero, result would equal zero (not a
negative) otherwise calculate j2-h2

  #3   Report Post  
 
Posts: n/a
Default

For personal preference

=MAX(J2-H2,0)

hth RES
Reply
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
I'm having trouble with a greater than,Less than formula Donna Excel Discussion (Misc queries) 2 June 17th 05 02:23 AM
Formula for placings, using 4 times and greater than minimum time handers Excel Worksheet Functions 2 May 12th 05 08:00 PM
Excel formula to make AAA-BBB equal to/consistent with BBB-AAA AliceJDavidson Excel Worksheet Functions 1 May 9th 05 09:30 PM
The formula to find the smallest number in a row not equal to zero seastheday Excel Worksheet Functions 8 April 14th 05 11:58 PM
Less than, Greater than Formula Debbie Excel Discussion (Misc queries) 1 April 13th 05 07:58 PM


All times are GMT +1. The time now is 10:45 PM.

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

About Us

"It's about Microsoft Excel"