Thread: if fuction in data validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sliman Sliman is offline
external usenet poster
  
Posts: 13
Default if fuction in data validation
I need to limit data validation based on value in cell refrance.
if(a1="Multi",b20,sumif(F:F,c2,H:H)=b2)

if a1="Multi" then any positive value including 0
if a1 not ="Multi" then sumif formular
Reply With QuoteReply With Quote