Skip to main content

My if formula isn't working for two different 'if' scenarios...

  • April 18, 2023
  • 3 replies
  • 36 views
I
Forum|alt.badge.img+1
I'm putting the below formula but it keeps coming up with an error message - any ideas why when each part seems to work independently.
 
IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) ), IF({Always On/Miniseries} = "Mini Series", {Total Budget (USD)}*{Year 1 (from Mini Series Amort) (from Start Date)})

3 replies

R
Forum|alt.badge.img+10
  • RdMedia_srl
  • Inspiring
  • April 18, 2023

you can try this

IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) , {Total Budget (USD)}*{Year 1 (from Mini Series Amort) (from Start Date)})

 

Rodolfo - RdMedia
I
Forum|alt.badge.img+1
  • imomarsx
  • Author
  • New Participant
  • April 18, 2023

I don't think this will work - as above I need the second part to work differently from the first, i.e. if Mini Series is selected the second line to apply.

TheTimeSavingCo
Forum|alt.badge.img+31

Try this:

IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) ) & IF({Always On/Miniseries} = "Mini Series", {Total Budget (USD)}*{Year 1 (from Mini Series Amort) (from Start Date)})

We can't use commas to separate functions and need to use `&`, so I replaced your comma with it; should work fine

Adam, Airtable Consultant - thetimesaving.company
Terms & ConditionsAccessibility statement