Thread: If then statements
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tommy[_2_] Tommy[_2_] is offline
external usenet poster
  
Posts: 5
Default If then statements
If any of A1, A2, or A3 are blank the result is 0 otherwise result is .25
Try this:

=IF(OR(A1="",A2="",A3=""),0,0.25)


Reply With QuoteReply With Quote