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

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.

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.