check box in formula
I want to create a formula where if c2 is not checked then d2 is b2, but if c2 is checked d2 is b2 *1.0625
Can anyone help with this .. I keep trying if scenarios with true and false but it's not working.
Mac mini, macOS 10.15
I want to create a formula where if c2 is not checked then d2 is b2, but if c2 is checked d2 is b2 *1.0625
Can anyone help with this .. I keep trying if scenarios with true and false but it's not working.
Mac mini, macOS 10.15
Hi timpany,
Formula in D2 =IF(C2,B2×1.0625,B2)
Regards,
Ian.
Thank you!...Keep it simple. I was completely overcomplicating it with a True, False. If/Then scenario.
check box in formula