Thread: chech if two or more cells = and return a value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default chech if two or more cells = and return a value
Use an AND, eg:
=IF(AND(A1=10,A2=20),value_if_true,value_if_false)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nev1956" wrote:
Hi
dose any one know how to check if two ore more cells are true and return a
value
e.g. if a1= 10 and a2= 20 then return a value or what ever it needs to be
Reply With QuoteReply With Quote