excel formula help if else

[Mallesh23]

Hi Team,

I am using formula to calculate interest, the formula is working
I am getting positive and negative values, Want to keep only positive values for negative values keep 0

using if else

=OFFSET(Interest!$G$2, 12-CEILING.MATH(A2/2200), 0)

Outtstanding	interest
4,400	-14
2,200	-23
0	0
4,400	-14
4,400	-14
6,600	28

 

[awoohaw]

Where is worksheet with the cell Interest!$G$2, where is cell A2?
What cell is your formula in (or is it the interest column)?

 

[kvsrinivasamurthy]

May be this

=Max(0,OFFSET(Interest!$G$2, 12-CEILING.MATH(A2/2200), 0))