View Single Post
 
Old 12-02-2012, 08:42 AM
oxicottin oxicottin is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Dec 2012
Posts: 5
oxicottin is on a distinguished road
Default If formula result is negative then display text

Hello, I have a formula that I need to display text instead of the number if its a negative number or a zero. How would the formula go? Thanks!

Code:
E12-MAX(0,I13-60)-K13)
Reply With Quote