Forum Discussion
Solved
how do you manipulate an individual cell value using an IF conditional
I would like to modify a cell value between its current value and 0 if another cell has a conditioning value in it. let's say the conditioning value = T and the target cell value = 34. If the cond...
That's good, if your scenario is so simple, GDW11 . Then... please mark NikolinoDE 's post as answer (:
=IF(A1="T", 0, B1)
This formula checks if the value in cell A1 is "T." If it is, the formula returns 0; otherwise, it returns the current value in cell B1.
Hope this will help you.