Thread
: [Solved]
If formula result is negative then display text
View Single Post
12-03-2012, 02:12 AM
macropod
Windows 7 64bit
Office 2010 32bit
Administrator
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
Try:
=IF(E12-MAX(0,I13-60)-K13)>0,E12-MAX(0,I13-60)-K13),"Text to display")
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
macropod
View Public Profile
Find all posts by macropod