Help with lots of formulas

[always28smiling]

Hi there,

I'm usually pretty good at figuring stuff out. I'm having a hard tim
with a sheet and need someone's help.

Ok this goes out to my customers to fill out and send back. Either in a
attachment or printed and sent.

Currently
Column A= Quantity (whole number value)
Column B= Name of Item (not relevant)
Column C= Date (not relevant)
Column D=Value ($.25-$15)
Column E=Value Total (=A2*D2)
Column F=2% (I'm using formula =ROUND((D2*$F$1),2)
Column G= Amount given (I'm using formula =IF(F2>0.1, 0.1,F2)
Column H= Total for Quantity (=G2*A2)
I give them about 85 lines to fill out and on the 86th line I have th
totals for all the columns with the goal being I just have to look a
the last row and the last column for the number I want to enter

Example

A=4
B=anything
C=4/15/13
D=$1.00
Then E will auto calculate to $4.00
Then F auto calculates to $.02
G also is $.02
And H is $.08 for the total for that line

What I want to know is if I can add a column where a customer can ente
either an "S" or and "I" and have that equal a percentage. "S"=5% an
"I"=2% from there to continue to calculate

Using the example above if the customer still enters
A=4
B=anything
C=4/15/13
D=$1.00
E=$4.00
F="S" or "I" and it will automatically know 5% or 2% based on the lette
entered
G=amount
H=(A*G)

Is this possible?

Please help. I can understand but I need the easiest to follo
spreadsheet for my customers. Basic Basic Basic. S and I is about al
they can handle.

Thank

 

[Living the Dream]

Hi

Using your template

For me, the simplest way would be the following:

Using the example above if the customer still enters
A=4
B=anything
C=4/15/13
D=$1.00
E=$4.00
F="S" or "I" and it will automatically know 5% or 2% based on the letter
entered (make this a Data Validation so that they can only choose S

or I).

G=If(F="S",.05,.02)

H=(E*G)
I=(A*H)

HTH
Mick

 

[Living the Dream]

Ooops

Try

or I).

G=If(F="S",.05,.02)

Mick

 

[always28smiling]

Thank you thank you!