Skip to main content

Three If formulas not working

  • May 18, 2023
  • 3 replies
  • 23 views
I
Forum|alt.badge.img+1

Hi all,

I've ran this code and don't have an error message coming up but when I click ok the final part of the 'If' formula is deleted.I'd like it to run so that all parts of the if formula work (three options):

 

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

3 replies

Teagan_Clark
Forum|alt.badge.img+3
  • Teagan_Clark
  • New Participant
  • 4 replies
  • May 18, 2023

Are those the only three options? You could try:

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

So do the calculations if it's the two that get calculated, otherwise display the Addition Budget. 

Ben_Young1
Forum|alt.badge.img+22
  • Ben_Young1
  • Brainy
  • 520 replies
  • May 19, 2023

Hey @imomarsx! 

Give this a shot:

IF( {Always On/Miniseries} = "Always On", {Total Budget (USD)} * ((13 - {Number (from Start Date)}) / 12), IF( {Always On/Miniseries} = “Existing Always-On", {Additional Budget 2023 (USD)}, IF( {Always On/Miniseries} = "Mini Series", {Total Budget (USD)} * {Year 1 (from Mini Series Amort) (from Start Date)} ) ) )
Alexey_Gusev
Forum|alt.badge.img+25
  • Alexey_Gusev
  • Brainy
  • 1260 replies
  • May 19, 2023

Hi,
I had such strange bug too, when entered formula accepted as valid, but end part dissapeared.
It ended when I refactored the formula and I never see such bug again.
I would use SWITCH in your case.


Terms & ConditionsAccessibility statement