If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
please help with formula
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)"&K21J21,75%*(K21-J21),0) |
#2
|
|||
|
|||
please help with formula
You need to use the AND function, like so:
=IF(and(I7="(00140)",K21J21),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 wrote in message ... 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)"&K21J21,75%*(K21-J21),0) |
Thread Tools | |
Display Modes | |
|
|