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