IF Function

Allie Gentry

Hi,

I am trying to create a formula one which there is two calculated values.

Here is what I created below.

=IF(ColumnName1< ColumnName2 - 3 * ColumnName3, IF(ColumnName3 > ColumnName2@ * 3, "True"))

Does not work for me...

First half of calculation

=IF(ColumnName1< ColumnName2 - 3 * ColumnName3

Second half of calculation

IF(ColumnName3 > ColumnName2@ * 3

If the two calculated values are equal = I want to be "True"

If the two calculated values "are not" equal = I want to be "False"

Any help with this is appreciated.

Connor Hartford

I believe the formula you want is the following:

=IF(ColumnName1 < (ColumnName2 - (3 * ColumnName3)), IF(ColumnName3 > (ColumnName2 * 3), 1, 0), 0)

Mike Wilday

Connor Hartford

I believe the formula you want is the following:

=IF(ColumnName1 < (ColumnName2 - (3 * ColumnName3)), IF(ColumnName3 > (ColumnName2 * 3), 1, 0), 0)

Mike Wilday

Allie Gentry

Thank you Mike and Connor question if you don't mind:

What does the 1 and 0 represent? Yes/No?

So for another formula would this be the way to create it

=IF(Col < 9), IF(RV1@row >1), 1,0))

Mike Wilday

The way the IF statement is built is like this.

=IF([column Name]@row = this, "Then return this result", IF([Column Name]@row > "this" , "then return this text", "this will return if none of the other statements are true)) 

So if you are wanting to compare some cells you would want to do it in the first section after the first IF statement.

Sharing a screenshot might help us help you better.

Connor Hartford

Yes 1 would equal "True" and 0 would equal "False", or Yes/No. Instead of 1 you can put "True" and instead of 0 you can put "False" in the same spot. It depends if you want it to show a 1 or 0 or the word "True" or "False", and it depends on the column type.

Your second formula has too many parentheses. I think it should look like this:

=IF(Col < 9, IF(RV1@row >1, 1,0))

OR

=IF(Col < 9, IF(RV1@row >1, "True","False"))