Hi, I'm tyring to have excel perform calculations if the cell is not blank, and display the minimum of all the calculated values. The problem I'm having is the MIN function isn't interpreting "" as a blank and returns #VALUE. I do not want the false condition of the IF statement to return a zero, b/c the MIN function would then calculate the 0 instead of ignoring it. Any help is greatly appreciated.
=MIN(((P21-K21)/K21),(IF(Q21<>"",((Q21-P21)/P21),""))
Try
IF(Q21<>"",(P21-K21)/K21,MIN((P21-K21)/K21,(Q21-P21)/P21)
Life's a spreadsheet, Excel!
Say thanks, Click *
Hello rsanford, and welcome to the forum.
I don't have your sample, so when I tried to emulate your error, I didn't get a value error. The only way I was able to generate any type of error was to turn K21 or P21 into a 0, which led to the #div/0 error. Could you provide a sample workbook with any sensitive information removed to illustrate exactly where you're having the issue?
Please click the star (add rep) if I helped!
Sure, it's attached
MIN function example.xlsx
thanks for your reply. However this logic doesn't quite match my goal.
If Q1 isn't blank, i need excel to tell me the min between the P21/K21 calculation, and the Q21/P21 calculation. If Q1 is blank, I need the Q21/P21 calculation to not occur and return a blank that MIN can ignore. Currently I'm unable to get MIN to ignore the return value of "" (#value error occurs).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks