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

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

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

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 -