Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
superfooz74
 
Posts: n/a
Default How to make a formula display results only if value is greater tha

I am new to Excel formulas. I assume i need an IF statement but not sure on
correct syntax
=D2-B2 is what i have now, what can i add to it so that it only displays
values 0?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
=IF(D2-B20,D2-B2,"")

"superfooz74" wrote:

I am new to Excel formulas. I assume i need an IF statement but not sure on
correct syntax
=D2-B2 is what i have now, what can i add to it so that it only displays
values 0?

  #3   Report Post  
Karl
 
Posts: n/a
Default

=if(d2-b20,d2-b2,"")
"superfooz74" wrote in message
...
I am new to Excel formulas. I assume i need an IF statement but not sure

on
correct syntax
=D2-B2 is what i have now, what can i add to it so that it only displays
values 0?



  #4   Report Post  
superfooz74
 
Posts: n/a
Default

Thank you for such a quick and accurate response.

"Frank Kabel" wrote:

Hi
=IF(D2-B20,D2-B2,"")

"superfooz74" wrote:

I am new to Excel formulas. I assume i need an IF statement but not sure on
correct syntax
=D2-B2 is what i have now, what can i add to it so that it only displays
values 0?

  #5   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
you're welcome :-)

"superfooz74" wrote:

Thank you for such a quick and accurate response.

"Frank Kabel" wrote:

Hi
=IF(D2-B20,D2-B2,"")

"superfooz74" wrote:

I am new to Excel formulas. I assume i need an IF statement but not sure on
correct syntax
=D2-B2 is what i have now, what can i add to it so that it only displays
values 0?



  #6   Report Post  
Harald Staff
 
Posts: n/a
Default

That depends on what you want to happen in the cell if D2 < B2.

Contain 0:
=MAX(D2-B2,0)

Contain empty string:
=IF(D2B2,D2-B2,"")

Contain negative number but hide it from view:
Menu Format Conditional formatting, criteria: value < 0 format: text color
same as background color.

Contain negative number but display zero:
Format Cells Number Custom number format 0;"0"
(or maybe it's a comma instead of a semicolon)

HTH. Best wishes Harald

"superfooz74" skrev i melding
...
I am new to Excel formulas. I assume i need an IF statement but not sure

on
correct syntax
=D2-B2 is what i have now, what can i add to it so that it only displays
values 0?



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
Excell only displays the formula, not the results René Excel Discussion (Misc queries) 3 December 28th 04 04:08 PM
Find & Replace results to display specified chosen fields samuel Excel Discussion (Misc queries) 1 December 28th 04 09:43 AM
Excel: To Display Formula in the cells Instead of Value [email protected] Excel Discussion (Misc queries) 1 December 10th 04 10:48 PM
I want the results of a formula to show in cell, NOT THE FORMULA! ocbecky Excel Discussion (Misc queries) 4 December 10th 04 09:39 PM
Paste is is copying in formula, but display is wrong. Matt Excel Discussion (Misc queries) 2 December 7th 04 09:37 PM


All times are GMT +1. The time now is 08:25 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"