IF formula

Stacy Stoffel

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

SoS | Dan Palenchar

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)

SoS | Dan Palenchar

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)

Stacy Stoffel

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

SoS | Dan Palenchar

@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!