Jan 15 2022 10:18 AM
Hi, most grateful if someone could help me with this. I need a conditional formula that would do the following:
If A1 > 15 then B2 = -5
is this poss?
thanks in advance
Jan 15 2022 10:28 AM - edited Jan 15 2022 10:48 AM
It is a bit vague.
What you can do is apply the AND() formula that will compare the both conditions and when sactisfying both will format the cell.
=AND(A1>15,
B2=-5)
Jan 15 2022 11:02 AM
Jan 15 2022 12:23 PM
SolutionOnly a formula entered into cell B2 is able to set the value of B2. You could have
= IF(A1>15, -5, other)
but that will prevent you entering any other values into column B. Any other values would have to be generated from the formula.
Jan 15 2022 02:26 PM
Jan 15 2022 12:23 PM
SolutionOnly a formula entered into cell B2 is able to set the value of B2. You could have
= IF(A1>15, -5, other)
but that will prevent you entering any other values into column B. Any other values would have to be generated from the formula.