Need help with my formula please

[davek]

This is from a spreadsheet passed over to me

=IF(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$3<0,0,MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,
$AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)


If I wanted to take the value that the above formula comes up with and
reduce it...say 25 percent or 10 percent...what would I add to the formula to
accomplish this? I'm a bit of a novice and this formula is beyond what I've
worked with in the past. Thank you.

[malik641]

I'm pretty sure this is what you're asking for:
For 25% reduction

=IF((MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$3)*0.75<0,0,(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,
$AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)*0.75)

For 10% reduction

=IF((MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$3)*0.90<0,0,(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,
$AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)*0.90)

This is from a spreadsheet passed over to me

=IF(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$3<0,0,MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,
$AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)


If I wanted to take the value that the above formula comes up with and
reduce it...say 25 percent or 10 percent...what would I add to the formula to
accomplish this? I'm a bit of a novice and this formula is beyond what I've
worked with in the past. Thank you.

[N Harkawat]

to reduce by 25% just multiply it by 0.75 as follows:-
=IF(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$3<0,0,MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,
$AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)*.75



"davek" <[email protected]> wrote in message
news:[email protected]...
> This is from a spreadsheet passed over to me
>
> =IF(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$3<0,0,MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,
> $AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)
>
>
> If I wanted to take the value that the above formula comes up with and
> reduce it...say 25 percent or 10 percent...what would I add to the formula
> to
> accomplish this? I'm a bit of a novice and this formula is beyond what
> I've
> worked with in the past. Thank you.

[Bob Phillips]

Improved as well as the amend you asked for

=MAX((MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$
3)*75%,0)

--
HTH

Bob Phillips

"davek" <[email protected]> wrote in message
news:[email protected]...
> This is from a spreadsheet passed over to me
>
>
=IF(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$3
<0,0,MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,
> $AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)
>
>
> If I wanted to take the value that the above formula comes up with and
> reduce it...say 25 percent or 10 percent...what would I add to the formula
to
> accomplish this? I'm a bit of a novice and this formula is beyond what
I've
> worked with in the past. Thank you.

[davek]

Thank you seems to be working. I appreciate the quick response.

-Dave

"Bob Phillips" wrote:

> Improved as well as the amend you asked for
>
> =MAX((MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$
> 3)*75%,0)
>
> --
> HTH
>
> Bob Phillips
>
> "davek" <[email protected]> wrote in message
> news:[email protected]...
> > This is from a spreadsheet passed over to me
> >
> >
> =IF(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,$AB7,,$AI7,$AL7,$AO7,$AR7,$AU7)-$E$3
> <0,0,MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y7,
> > $AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)
> >
> >
> > If I wanted to take the value that the above formula comes up with and
> > reduce it...say 25 percent or 10 percent...what would I add to the formula
> to
> > accomplish this? I'm a bit of a novice and this formula is beyond what
> I've
> > worked with in the past. Thank you.
>
>
>