Using referenced cell text & number values in formulas

[mellymelle]

Hi, I'm trying to use mathematical operators & numbers in cells to write a formula. For example, rather than:

=IF(C1<5, 1, 0)

If < is the value in A1, 5 is the value in B1, how would the formula be written? Tried = IF(C1&A1&B1, 1, 0), but doesn't work.

 

[AliGW]

Try this:

=IF(INDIRECT("("&C1&A1&B1"&, 1, 0)")

 

[mellymelle]

Unfortunately didn't work. The formula is short one closing bracket, tried putting it at the end but no dice.

 

[63falcondude]

I would like to know the answer to this as well. I'll see if I can come up with something.

 

[63falcondude]

Try

=IF(COUNTIF(C1,A1&B1),1,0)