Thread: [Solved] If formula result is negative then display text
View Single Post
 
Old 12-03-2012, 01:39 AM
Kevin@Radstock Kevin@Radstock is offline Windows 7 32bit Office 2010 32bit
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
Hi oxicottin

Try: =IF(E12-MAX(0,I13-60)-K13)<=0,"Your text here if true","Your text/value here if false")
Reply With Quote