Hi there,

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

Ok this goes out to my customers to fill out and send back. Either in an 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(F20.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 the totals for all the columns with the goal being I just have to look at 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 enter either an "S" or and "I" and have that equal a percentage. "S"=5% and "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 letter entered
G=amount
H=(A*G)

Is this possible?

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

Thanks

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

Ooops

Try
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=(E+H) <------ Erata


Mick

Thank you thank you!!