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
Bookmarks