Assign values to range?

  • Thread starter Thread starter bishopwill
  • Start date Start date
B

bishopwill

I have a formula that if true, will assign values to a range of cells
Was trying
IF(some value, B2:C2=1,)
but it's doing a true/false comparison on the range rather than fillin
the values. Please hel
 
Hi
a formula can't fill other cells. It can only return a value to the
cell from which the function is invoked. So the formula below won't
work
 
Frank is correct...

Perhaps you're looking to do something like
... in B2 & in C2: =IF($A2>0,1,"")
 
Back
Top