Formula for percentage not to exceed 100%

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Mar 5, 2007

• #2

Try

=IF(AND(M12<>"",N12<>""),MIN(N12/M12*100,100),"")

 

Upvote 0

levipe

Active Member

Joined

Nov 20, 2006

Messages

310

• Mar 5, 2007

• #3

Depends on what you want to happen if it would be over 100, but:

=IF(AND(M12<>"",N12<>"",M12>=N12),N12/M12*100,"")

Click to expand...

 

Upvote 0

Thorin

Board Regular

Joined

Feb 8, 2007

Messages

243

• Mar 5, 2007

• #4

Try :-

Code:

=IF(N12>M12,100,IF(AND(M12<>"",N12<>""),N12/M12*100,""))

 

Upvote 0

J

jmattus

Board Regular

Joined

Mar 2, 2007

Messages

137

• Mar 5, 2007

• #5

Try this:

=if(and(m12<>"", n12<>"", m12<>0), if(n12/m12>1, 1, n12/m12*100), "")

JM

 

Upvote 0

barry houdini

MrExcel MVP

Joined

Mar 23, 2005

Messages

20,825

• Mar 5, 2007

• #6

Perhaps

=IF(N12="","",IF(M12,MIN(1,N12/M12)*100,""))

 

Upvote 0

L

Lamar in Houston

Board Regular

Joined

Jan 21, 2006

Messages

72

• Mar 5, 2007

• #7

RE: Not exceeding 100%

Thanks for all the good tips. The MIN function did the job for me.

Many thanks

 

Upvote 0