Hello Everyone,

I am looking for a formula that will place a number in column B if Column A has a check box that is checked.

Thanks in advance.




=IF([Column A Title]23 = 1, 3000) 

Put this formula in Column B and replace Column A Title with the actual column name. And change the row 23 - to whatever row number it is.  Then change the number 3000 to whatever number you want.