# IF formula

Options
✭✭✭✭✭

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))

• ✭✭✭✭✭✭
Options

I'm assuming that "Existing current WJA server" is your checkbox column. If so, I would try the below formula.

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

School of Sheets (Smartsheet Partner)

If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

• ✭✭✭✭✭✭
Options

I'm assuming that "Existing current WJA server" is your checkbox column. If so, I would try the below formula.

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

School of Sheets (Smartsheet Partner)

If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

• ✭✭✭✭✭
Options

Thank you so much! I thought i tried that...I must have had that second IF in place.

• ✭✭✭✭✭✭
Options

@Stacy Stoffel You're welcome! Technically the second IF would still have worked if the argument was set to be equal to 1 (you had = 2 which is not a value for a checkbox), but better to be as efficient as possible in my opinion!

School of Sheets (Smartsheet Partner)

If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!