Assign values to range?

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
 
F

Frank Kabel

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
 
M

Max

Frank is correct...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Remove Identical words 0
Finding the right style field in VBA 0
Hyperlinks with lookups 0
Pasting a cell into bookmarked table from excel vba 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Avoiding auxiliary cells 0
VBA multiple list of values for variable 1

Top