Excel formula skip blanks with multiple conditions.

Hello Again,

I am looking for a help for single line formula with multiple conditions as mentioned below.

- The formula look for nonblank cell values in columns G, H & I and apply calculation
- After above validation the formula look for small value if multiple cell are non-blanks found.

Kindly note that the attached is a sample only the original data is huge with 6-9 hundred thousands.

Copy of sample report is attached.

Do you really want a formula for 900,000 records?

Pete

Thank you for your response on my above request.

I have a question.

Actual calculation is 94.78 - (94.78 * 12.00%) = 83.4064 and toe formula is =F11-(F11*I11)

Now your first formula =F11*(1-IFERROR(1/(1/MIN(G11:H11)),12%)) it is giving result 81.5108 which is wrong.

And your second formula which is =F11*(1-MIN(G11:I11)) it is giving correct result which is 83.4064

So can you explain what is the difference between these 2 formulas which is giving 2 different results.

just to learn and not bother to you again if their is any changes in the data.

Thank you once again.

Thanks for your explanation. It really help to understand the formula.