Solved If statement not working

April 22, 2013 at 07:45:39
Specs: Windows XP
=IF(AND(C14="not grossed up",G6="CA",L10*-0.01,0))

Why will this if statement not work? I'm trying to calculate only if the two condisitons are meet 1st.

Thank you

See More: If statement not working

Report •

April 22, 2013 at 08:02:10
✔ Best Answer
Try this and let me know what happens...

=IF(C14="not grossed up", IF(G6="CA", L10*-0.01,0), 0)

Report •

April 22, 2013 at 08:07:44
Worked great. Thank you, Carrie

Report •

April 22, 2013 at 08:13:48
Don't forget to mark the best answer if your question has been answered so others know this thread is solved. Thanks!!

Report •
Related Solutions

Ask Question