MIN and ISNUMBER functions

[jsd_91]

I really am not big in excel but know some of the basics.

Trying to calculate the percentage completed of a target set. Due to other formulas in the spreadsheet, I have had to use the ISNUMBER function so that it only returns a result if there is data to pull (instead of giving me a #DIV/0 error) which was fine. Then I realised that if they overachieved their target, it would give me a result over 1.00 (or 100%) so I put a cap on this to stop it using =MIN(forumla,1). But now when I apply the MIN function, it overrides the ISNUMBER function and I am left with #VALUE ! in cells with no data to pull from.

This is the formula I have used so far:

=MIN(IF(AND(ISNUMBER(B3),ISNUMBER(C3)),C3/B3," "),1)

In this instance, Column B gives the target (number) and Column C gives the number completed (number)

Any help for this very inexperienced individual would be massively appreciated.

 

[njimack]

=if(c3*b3,min(c3/b3,1),"")

 

[jsd_91]

=if(c3*b3,min(c3/b3,1),"")

Thank you a million times