finding with 3%

[wtranger8]

im so I have a box that is 15.1 inches and I have a self that is 15 ins high . if I change it to 15 it will fit but if the change is no over 3% change it when then revert back to 15.1 what is the excel formula for this can anyone help me the info would be cell a2 the 15 for the self height and the box height 15 and I would want the answer in c2 I am a beginner at writing formula ya thanks to anyone that can help me

 

[JackDanIce]

Welcome to the board. In C2 try:

=IF(B2-A2<=0.97*B2,A2,B2)

 

[wtranger8]

Welcome to the board. In C2 try:

=IF(B2-A2<=0.97*B2,A2,B2)

I did that and this is what it came up with

[TABLE="width: 192"]

<colgroup><col width="64" style="width: 48pt;" span="3">
<tbody>[TR]


[TD="width: 64, bgcolor: transparent, align: right"]12[/TD]

[TD="width: 64, bgcolor: transparent, align: right"]15.5[/TD]

[TD="class: xl63, width: 64, bgcolor: transparent, align: right"]12[/TD]


[/TR]

</tbody>[/TABLE]

 

[JackDanIce]

Your initial post wasn't clear, so was best attempt. Can you give two examples with inputs and expected outputs?

 

[wtranger8]

ok so I have a location height that is 15 and the box is 15.1 I need to change the box to 15 for it to fit in the location but if the change doesn't its 3% of the box height the computer will reset it back to its default of 15.1 I have other locations that 12 high but the case is 25 I know that u cant fit that in a location it 2 small I quess what im looking for is I want what ever the box is to be reduced by 3% so that the change will stay I need to fool the computer so that the change will work and stay there im not very good at explaining things



[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]location height [/TD]
[TD]box height [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]5[/TD]
[TD]it wont fit because it physical fit so even if I faked it it wont fit in location [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4.1[/TD]
[TD]it will fit but if I change the box height but 3 % so change will stick[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[JackDanIce]

It's still not clear, however, try:

=IF(OR(B2>A2,1.03*B2>A2),A2,B2)