Thread: If statement for cell ranges to equivalent value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rechie Rechie is offline
external usenet poster
  
Posts: 57
Default If statement for cell ranges to equivalent value
Hi,

Formula to get a equivalent of fixed value.

Formula to type in A1:
If range A2:A10=non blank (numeric value),
then A1=20.

Appreciate your time and help.

Rechie


Reply With QuoteReply With Quote