Forum Discussion

aaroncre's avatar
aaroncre
Copper Contributor
Nov 28, 2020

Problems creating iterative calculations in If statements

Hello,   Microsoft support directed me to look for some help with my issue here. I am currently trying to do some modeling which requires some iterative if statements such as  "=IF$D10=(0,25,D10 D7...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 29, 2020

aaroncre 

That will be great if you provide exact formula you use since one which is in your post shall not work on any computer - incorrect syntax for IF(), there are no such numbers as 1000$, etc. Perhaps you mean

=IF($D10=0,25,D10)*D75/1000
  • aaroncre's avatar
    aaroncre
    Copper Contributor
    Nov 29, 2020
    =IF$D10=(0,25,D10+D75/1000)

    Sorry thats what it should say.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 29, 2020

      aaroncre 

      That means

      =IF($D10=0,25,D10+D75/1000)

or

if d10 is zero
then d10=25
else d10=d10+d75/1000

       

Resources