Need help with my formula please
 

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.

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" wrote in message
...
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.

Improved as well as the amend you asked for

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

--
HTH

Bob Phillips

"davek" wrote in message
...
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.

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,$AI 7,$AL7,$AO7,$AR7,$AU7)-$E$
3)*75%,0)

--
HTH

Bob Phillips

"davek" wrote in message
...
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.

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,,$AI 7,$AL7,$AO7,$AR7,$AU7)-$E$3)*0.75<0,0,(MAX($D7,$G7,$J7,$M7,$P7,$S7,$V7,$Y 7,
$AB7, , $AI7, $AL7, $AO7,$AR7,$AU7)-$E$3)*0.75)

For 10% reduction

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

davek Wrote:
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
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=384994