Thread: formula checking if all cells are greater than x
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tami Tami is offline
external usenet poster
  
Posts: 123
Default formula checking if all cells are greater than x
Hi....

i need a formula that asks if cell A13 and B1 3 and c13 and D13 then
return "ALL", otherwise "No"...in other words if all the cells in A1:D1 are
greather than 3 then "ALL".
anyone?....


Reply With QuoteReply With Quote