Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |