IF Function
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.
Best Answers
-
I believe the formula you want is the following:
=IF(ColumnName1 < (ColumnName2 - (3 * ColumnName3)), IF(ColumnName3 > (ColumnName2 * 3), 1, 0), 0)
Connor Hartford
-
Answers
-
I believe the formula you want is the following:
=IF(ColumnName1 < (ColumnName2 - (3 * ColumnName3)), IF(ColumnName3 > (ColumnName2 * 3), 1, 0), 0)
Connor Hartford
-
-
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))
-
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.
-
Yes
1
would equal "True" and0
would equal "False", or Yes/No. Instead of1
you can put"True"
and instead of0
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"))
Connor Hartford
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!