IF formula to calculate amount in different columns

Good morning,

I have the following spreadsheet that calculates a percentage of the amount in one column based on the minimum of two amounts

My formula in column G calculates the amount from column B by percentage in column F, but if looks in column C and it takes the minimum amount of both columns. What I would like is to add that if column I = 0 to calculate the amount in column B and if not = 0 calculate the amount from column I. I still want to keep the MIN of either column C or G. Let me know if the attachment is not available.

Thanks

Try in B2:

Formula:

Please Login or Register  to view this content.

Thanks but this is not want I wanted to do the above formula enters the amount from column I, the formula I have is what I want, but I would like to add an IF statement and not sure where to add it in the formula.

If you look in the following attachment, row 3 and 4, the amount in column I is 0, therefore, I would like the MIN formula to calculate amount in column A
If you look in row 2 and 5, there is an amount in column I, I would like the MIN formula to calculate amount in that column
The salary increase in column G cannot go above the Jrate amount in column B, as this is the maximum allowable amount

Thanks

Which column do you want the calculations? Are the values in the calculated column what you want to achieve?

It would be better if you show the input cells then what you want in the calculated cells with results please. I would leave the input cells with no fill and the calculated cells with a fill color.

Thank you

I hope someone can understand what you are trying to do sorry that I could not.

Thanks and ok I have attached a revised spreadsheet, the column highlighted in yellow is where I would like the input formula that adds an IF statement to the current one. It is now calculating from amount in column A and multiply by percentage in column F, but cannot go over the maximum amount in column B after calculation. I would like to add the IF statement to look in column I and if it is 0 to calculate from column I and if not column A.

When you look at the amount in row 5, the 4% indicated in column F after the calculation is much higher than the difference to maximum indicated in column C, therefore, inputs that amount instead of actual 4% increase to column A.

A also added some explanations to the spreadsheet attached trying to detailed what I would like the formula to do.

Thanks

Thank you, I managed to find it on my own and the formula that works is the following:

=MIN(I2,ROUND(IF(AY2=0,G2*L2,AY2*L2)-2,-2))