If statement???

[rhenry2424]

Am I able to write a double IF statement.
Basically, I want to combine:

If OR if........


=IF($AI$31*1000=D14,0,$AI$31*1000)

=IF($AI$31*1000=c14,0,$AI$31*1000)

Or is there another way to write this and still get it to do what I want.

Basically, this is for CUMS.... 30, 60, 90 day cums. I want to automatically link the data back to other sheets so I have it all in one area. My daily *** is already being calculated in one column. I want to reference the cell for day 30, then 60, then 90...etc, since this column is already calculating. If there is only 45 days of production, day 60 & 90 shows the same numbers. If it is the same, I want it to show 0

[oeldere]

Try this one.

=IF(OR($AI$31*1000=D14,AI$31*1000=c14),0,$AI$31*1000)

[rhenry2424]

Thank you for your help. I am saving this for future use.

I am unable to use this formula for my stuff right now, though. Driving home yesterday I realized that this would bring back incorrect data.

I have a column for daily #'s (I insert daily) and a column for the cumulative numbers (This is pre-calculated through 2000 days). the only way that day 30 & 60 would have the same numbers would be if it is less than 30 days. The numbers would be different if there were only 38 days so far, so I would be pulling incomplete cumulative data from day 60.

I realized that i need my if statement to read:
=IF($AH$31="",0,$AI$31*1000)
AH being daily data and AI being cumulative data.

Once again I was overthinking the simplicity of what I needed to do.

Thank you for your help though. The calculation will come in handy in the future!