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 again
Michael helped me with part of this earlier today. I'm
stuck again. The below formula works well; however, I want to add "(35200)" and "(35300)" to the formula in additon to the "(00140)" and cannot get it to work. Can you help? =IF(AND(I7="(00140)",K21J21),75%*(K21-J21),0) |
#2
|
|||
|
|||
please help again
Do you want
=IF(AND(OR(I7="(00140)",I7="(35200)",I7="(35300)") ,K21J21),75%*(K21-J21),0) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... Michael helped me with part of this earlier today. I'm stuck again. The below formula works well; however, I want to add "(35200)" and "(35300)" to the formula in additon to the "(00140)" and cannot get it to work. Can you help? =IF(AND(I7="(00140)",K21J21),75%*(K21-J21),0) |
#3
|
|||
|
|||
please help again
Thank you so much Bob, that is exactly what I wanted and
could not get. You too are a keeper -----Original Message----- Do you want =IF(AND(OR (I7="(00140)",I7="(35200)",I7="(35300)"),K21J21), 75%*(K21- J21),0) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... Michael helped me with part of this earlier today. I'm stuck again. The below formula works well; however, I want to add "(35200)" and "(35300)" to the formula in additon to the "(00140)" and cannot get it to work. Can you help? =IF(AND(I7="(00140)",K21J21),75%*(K21-J21),0) . |
Thread Tools | |
Display Modes | |
|
|