Best answer

IF OR in Numbers

  • 12 April 2021
  • 2 replies
  • 58 views

Hi,

 

I’m trying to build something that shows me the total value of products in a basket that meet slightly fuzzy condition. I’m using utilities and Number to do this but it means I need to use 5 tasks to do something that feels like it could be done in one.

 

IF("{{119107523__output__Products[]Items}}"="Family Main WGA +Don","{{119107523__output__Products[]Values}}","")

 

Any thoughts on how I could do something a little more like an IF OR? 

 

icon

Best answer by XRay Tech 12 April 2021, 18:34

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Badge +4

Hi @TOMCPG you can try a “Spreadsheet Style Formula” inside Formatter.

 

Inside Formatter select Numbers.  Then select Spreadsheet Style Formula from the dropdown inside the “Transform” field.  Then enter your formula inside the “Forumla” field below.

 

You can read more about Zapier supported formulas here: https://zapier.com/help/create/format/understand-spreadsheet-style-formula-functions

Userlevel 7
Badge +14

Hi @TOMCPG 

Code steps, although more technical, allow for all sorts of custom logic to be done in 1 step: https://zapier.com/apps/code/help