| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Assist With Formula Creation
I'm using Office 2000 Pro (Excel) and usually do okay with formulas but I am
stuck with the following: G1 = $amt H1 = G1 less 20% J1 = G1 less 80% + I1 (I1 = $amt) Thanks, Rick |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Assist With Formula Creation
Try these:
H1: =G1*0.8 J1: =G1*0.2 + I1 Hope this helps. Pete On Dec 28, 2:27*pm, Rick wrote: I'm using Office 2000 Pro (Excel) and usually do okay with formulas but I am stuck with the following: * G1 = $amt H1 = G1 less 20% J1 = G1 less 80% + I1 * (I1 = $amt) Thanks, *Rick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Assist With Formula Creation
Perfect. Thanks for your help. Rick
"Pete_UK" wrote: Try these: H1: =G1*0.8 J1: =G1*0.2 + I1 Hope this helps. Pete On Dec 28, 2:27 pm, Rick wrote: I'm using Office 2000 Pro (Excel) and usually do okay with formulas but I am stuck with the following: G1 = $amt H1 = G1 less 20% J1 = G1 less 80% + I1 (I1 = $amt) Thanks, Rick |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need Assist With Formula Creation
You're welcome, Rick - thanks for feeding back.
Pete On Dec 28, 2:54*pm, Rick wrote: Perfect. *Thanks for your help. *Rick "Pete_UK" wrote: Try these: H1: * *=G1*0.8 J1: * * =G1*0.2 + I1 Hope this helps. Pete On Dec 28, 2:27 pm, Rick wrote: I'm using Office 2000 Pro (Excel) and usually do okay with formulas but I am stuck with the following: * G1 = $amt H1 = G1 less 20% J1 = G1 less 80% + I1 * (I1 = $amt) Thanks, *Rick- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula creation | Excel Discussion (Misc queries) | |||
| Formula Assist | Excel Discussion (Misc queries) | |||
| Formula creation...if possible | Excel Worksheet Functions | |||
| Rosters - is there a function or formula to assist with this | Excel Discussion (Misc queries) | |||
| Making Array Formula, please assist! | Excel Worksheet Functions | |||
Hybrid Mode
