please help with formula

G

Guest

I tried the following formula and I should be receiving a
result of 0 because I7 has "(001234)" in it,
not "(00140)". For the record, K21 is greater than J21.
It's appears that the "&" is being ignored, can you please
help? Thank you.

=IF(I7="(00140)"&K21>J21,75%*(K21-J21),0)
 
M

Michael Malinsky

You need to use the AND function, like so:

=IF(and(I7="(00140)",K21>J21),75%*(K21-J21),0)

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

please help again 2
If Function 3
Wrong Result--Help! 4
Help with correcting writing a formula 4
AVERAGE Row of Numbers and Return Corresponding Numeric Label 14
Use TODAY() function as the criteria in a SUMIF formula 1
Custom Validation formula for business rules 3
Finding the weighted average of text that have been given values 1

Top