need help with excel

[posol]

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....

 

[posol]

nevermind. i figured it out myself

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

 

[Bob Vila]

 

[CRX-YEM]

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.

 

[Tonyd0821]

fuck math

 

[CRX_B16B]

 

[Bob Vila]

Originally posted by CRX-YEM@Nov 6 2003, 10:40 AM

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.

welcome to my world...

 

[Tonyd0821]

in out

 

[JDMilan]

a decent reference source for excel formulas is that quick guide that college book stores usually sell, it only costs like 5 bucks and might be useful in the future for you B.