View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yh73090[_3_] yh73090[_3_] is offline
external usenet poster
 
Posts: 1
Default If Statement Help

What I need is to add that if G11 and H11 are blank then make th
cellcolor white.

=IF(OR(I$10$H$11,I$10<$G$11),"",IF(I$10=$G$11,$G$ 11,$G$11+((I$10-$G$11)/$G$4)*$G$4))


Appreciate any help.

Y

--
Message posted from http://www.ExcelForum.com