[ezpt]

This is what I am trying to do..

IF A7=M then use formula 'A' if not use formula 'B'.

This is how I wrote it..

=IF(E17=M,"=4.95/(AG17)-4.5)*100","=4.95/(AI17)-4.5)*100")

It did not let me use the letter so I tried it with a 1.

=IF(E17=1,"=4.95/(AG17)-4.5)*100","=4.95/(AI17)-4.5)*100")

The function works, but it enters the code (=4.95/(AG17)-4.5)*100) not activating the formula.

Is there a way to default to the formulas (A, B) and also to use an M for the IF function?

[etaf]

IF A7=M then use formula 'A' if not use formula 'B'.

=if( a7="M", formulaA, formulab)

[etaf]

Try this

=IF(E17="M",4.95/(AG17)-4.5)*100,4.95/(AI17)-4.5)*100)

I havent check - will do now

The brackets are all wrong

So what do you want to calculate first in the formula

formualA
4.95/(AG17)-4.5)*100
so you can see you have a closed backet and no open

Formula B
4.95/(AI17)-4.5)*100
same here

I assume it should be at the beginning

(4.95/(AG17)-4.5)*100

and

(4.95/(AI17)-4.5)*100

so

=If(A17="M", (4.95/(AG17)-4.5)*100, (4.95/(AI17)-4.5)*100 )
should work


OR
depending on the calc you want to do first

=If(A17="M", 4.95/((AG17)-4.5)*100, 4.95/((AI17)-4.5)*100 )

[ezpt]

That was great this has been kicking my butt for a couple days. It's great that there are great minds out there willing to help. I just started using the Excel program and have been using only trial and error. I will be watching this board and library trying to learn more.

Thanks again.

[etaf]

if thats all OK now - you can now mark as solved - button at top of your first post

Any more questions on other excel issue - just post a new post