If Then Formula

[sneakybeakylike]

Hi All!

I'm having a bit of trouble with some formulating... How can I write an If Then statement into a cell so that it displays the value of another cell, or cells?

For example, If A1 > 10, Then B1 = (the value of Cell X)

Thanks a ton!

 

[VBE313]

Are you trying to set B1 to the value of Cell X (ex. X1)?

 

[sneakybeakylike]

No, those were just example values. Here's what I actually need it to do:

If (K2 > 1) Then (Value of F2) = F2 + 0.1

I also plan on replicating the formula all the way down column F.

 

[VBE313]

=IF(K2>1,F2+0.1,0)

 

[sneakybeakylike]

Oh cool, I was just dumb and using quotation marks.
Thanks

 

[VBE313]

You aren't dumb, sometimes we tend to overthink the simplest of tasks!