I'd like to do the following: =IF(A1=10, B1="Right", "Left") If not IF, then how? Thanks.
R Ricter Feb 8, 2006 #1 I'd like to do the following: =IF(A1=10, B1="Right", "Left") If not IF, then how? Thanks.
B bpeltzer Feb 8, 2006 #2 Formula results show up in the cell where the formula is located. BUT, they can (and usually do) take other cells as inputs. So put the formula in cell B1 (where you want the result): =if(a1=10,"Right","Left")
Formula results show up in the cell where the formula is located. BUT, they can (and usually do) take other cells as inputs. So put the formula in cell B1 (where you want the result): =if(a1=10,"Right","Left")
R Ricter Feb 8, 2006 #3 Well, unfortunately, if I put the formula in B1, then I'll want it to change the value of cell C1 if A1=x... Sounds like it can't be done, at least not with IF.
Well, unfortunately, if I put the formula in B1, then I'll want it to change the value of cell C1 if A1=x... Sounds like it can't be done, at least not with IF.
