formula problem
Posted by Mindy on February 01, 2002 5:56 PM
I have a formula that I can't figure out.... this is my formula
=IF(AND(K3)=2,RIGHT(I3)="E",43.00),if (and(k3)=2,right(i3)="F",71.75,0)
I am saying if there is a 2 in k3 and if the right letter is an E then total is 43.00 else, if k3 is a 2 and if the right letter is a F then total is 71.75.
But it is coming up with my formula contains and error and the longer I look at it the more I see nothing..
Can Anyone Help Me Out?? Thanks for your time...
Posted by Larry on February 01, 2002 6:12 PM
You are a little off on your use of the AND function. Tell me a little more about the conditions and the data in the cells.
My first stab at this would be:
if(and(isnumber(find("2",K3)),right(K3,1)="E"),43,if(and(isnumber(find("2",K3)),right(K3,1)="E"),71.75,0)
Not really sure about the details of your criteria.
Posted by Mindy on February 01, 2002 6:21 PM
More Detail
What I am looking for is insurance codes. I extracted the codes by using a 1, 2, or 3. I got the 1 to work out just fine but I cannot seem to get the next one to go for me.
I will say in English what I am trying to get.
If K3 contains a 2 and if I3 = E(in my codes, which are LMDE are in I3) then I want it to put 43.00 in my active cell else if K3 contains a 2 and if the last letter in I3 is a F then I need it to put in 71.75 and if none of these conditions are true then just put a 0.
Posted by David on February 01, 2002 6:24 PM
Re: More Detail
Try: =IF(AND(ISNUMBER(FIND("2",K3)),RIGHT(I3,1)="E"),43,IF(AND(ISNUMBER(FIND("2",K3)),RIGHT(I3,1)="F"),71.75,0))
Posted by Larry on February 01, 2002 6:28 PM
Cell Reference
Oops, that change of cell reference from David should fix it.
Posted by Mindy on February 01, 2002 6:33 PM
Thank You.. Works like a Charm...
