# need help with excel

Discussion in 'Members' Lounge' started by pissedoffsol, Nov 6, 2003.

1. ### pissedoffsolRETIRED

Messages:
49,468
54
Joined:
Sep 28, 2002
Location:
Retirement Home
so here i am, a certified computer nerd, and i can't figure this shit out.

i need to calculate a cell for sales tax using the IF() function.

=IF(State="CT",D12*0.06,0)

where state = state defined cell
d12 = subtotal
.06 = ct state tax
or, 0 if not ct.

it comes up as #name in the field.... meaning a field is not recognized in the field.

i tried using b5 instead of "state", and it gives the same error

tried no quotes.... comes up always as false....

2. ### pissedoffsolRETIRED

Messages:
49,468
54
Joined:
Sep 28, 2002
Location:
Retirement Home
nevermind. i figured it out myself

i had a space in the "state field drop down, thus 'ct' != ' ct'

Messages:
4,672
61
Joined:
Jul 4, 2003
Location:
Bristol, Ct.

4. ### CRX-YEMSuper ModeratorModeratorVIP

Messages:
4,627
64
Joined:
Sep 29, 2002
Location:
Wallingford, CT

man I love excel formula's I wish I noticed this earlier

look what I had to do yesterday to check some final test data of ours

=IF(AND(AND(H3<=4.75,H3>=4.25),(AND(I3<=0.75,I3>=0.25))),"P","F")

and on top of the formula is does conditional ormating, ie if the answer is P leave cell as is, if answer if F then turn cell Red.

that's the cleaned up version.
you should of seen the tring of nested If statements I was using.

using excel functions are a bitch.

Messages:
5,088
0
Joined:
Feb 26, 2003
fuck math

6. ### CRX_B16BSenior Member

Messages:
386
0
Joined:
Oct 7, 2003

Messages:
4,672
61
Joined:
Jul 4, 2003
Location:
Bristol, Ct.

welcome to my world...

8. ### Tonyd0821Banned

Messages:
5,088
0
Joined:
Feb 26, 2003
Code:
`in out `

Messages:
6,730