IF formula

Can someone tell me what I am doing wrong with this formula? If the checkbox is checked, I need the value to be zero, if it is not checked then I need the formula to work:

=IF([Existing current WJA server]@row = 1, 0, IF([Existing current WJA server]@row = 2, [How many WebJet Admin Server Instances required?]@row * 4))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!