working with 2 if and statements

[napalm747]

I am sure this forum gets a lot of posts like this and first off I want to thank everyone for their patience with a novice like me. I am trying to get the below formula to work. Can someone help me figure out what is wrong with it or how to better write it? Thanks

=IF(AND(I4>330, K8="Pounds"),7305-G46, 6690-G46), IF(AND(I4>330, K8="Kilos"), 3313-G46, 3034-G46)

What I am trying to do is allow the entry of Kilos or pounds in one cell to determine which formula is used. So for instance, if the I4 value is >330 and K8="pounds" then I would use 7304. If those aren't true (for instance Kilos was entered or I4<330 then it would use 6690. I also need the same thing is Kilos were to be entered but at the kg values. I am trying to combine the 2 if and statements into one cell but am not really sure how to do that as the above formula won't work and I get lots of #### in the cell.

[dilipandey]

Hi napalm747,

suggest you to change the thread title to reflect the query you are asking.. see the forum rules;-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

[zbor]

Rob:

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

[zbor]

napalm747:

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.