Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: Cell calculation but only show if greater than 1 1

Status
Not open for further replies.

wayneryeven

Technical User
May 21, 2004
101
GB
Hey guys
I have the following calc going on:
=IF(ISBLANK(G19),"",G19-O19)

You follow the logic, BUT i want to only show it if the result is a positive number ie. >0

How best to achive?

Cheers guys for your effort.
 



Hi,

With another IF...
[tt]
=IF(ISBLANK(G19),"",if(G19-O19>0,G19-O19,""))
[/tt]



Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top