What is the best way to combine these 2 formulas and simplify it.
=IF(SPECIES@row = "Roses", IF([TYPE OF POT]@row = "LPD", IF(PINK@row = "", IF(RED@row = "", [Type]@row / 72, (PINK@row + RED@row / 4) / 72))))
=IF(SPECIES@row = "Roses", IF([TYPE OF POT]@row = "LPS", IF(PINK@row = "", IF(RED@row = "", [Type]@row / 36, (PINK@row + RED@row / 4) / 36))))
Best Answers
-
Hi @Mary Kam
If I'm understanding you correctly, you want to run the first formula if all the criteria are met, and if not (ex. if TYPE OF POT is "LPS" instead of "LPD"), then run the second formula.
If so, try something like this:
=IF(AND(SPECIES@row = "Roses", [TYPE OF POT]@row = "LPD"), IF(AND(PINK@row = "", RED@row = ""), Type@row / 72, (PINK@row + RED@row / 4) / 72), IF(AND(SPECIES@row = "Roses", [TYPE OF POT]@row = "LPS"), IF(AND(PINK@row = "", RED@row = ""), Type@row / 36, (PINK@row + RED@row / 4) / 36)))
It uses the "Value if False" to go into your second statement. Let me know if this works for you and if it makes sense!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you for your rapid response, it worked perfectly.
Answers
-
Hi @Mary Kam
If I'm understanding you correctly, you want to run the first formula if all the criteria are met, and if not (ex. if TYPE OF POT is "LPS" instead of "LPD"), then run the second formula.
If so, try something like this:
=IF(AND(SPECIES@row = "Roses", [TYPE OF POT]@row = "LPD"), IF(AND(PINK@row = "", RED@row = ""), Type@row / 72, (PINK@row + RED@row / 4) / 72), IF(AND(SPECIES@row = "Roses", [TYPE OF POT]@row = "LPS"), IF(AND(PINK@row = "", RED@row = ""), Type@row / 36, (PINK@row + RED@row / 4) / 36)))
It uses the "Value if False" to go into your second statement. Let me know if this works for you and if it makes sense!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you for your rapid response, it worked perfectly.
-
Wonderful! I'm glad I could help.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!