Skip to main content

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)}))

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. 

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)} ) ) )

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