help writing a formula

[chaos]

Hi all,

I wish to write an if formula with two if arguments, such as this:

=IF(A1=TRUE+A2=Bull,10%,-10%)

When I write the formula exactly as above, I get this result:
#Value!

When I write it like this:

=IF((A1=TRUE)+(A2=Bull),10%,-10%)

I get this result: #Name?

What am I doing wrong?

Any help would be appreciated.

Regards,

chaos

 

[Von Pookie]

Try: =IF(AND(A1="TRUE",A2="Bull"),10%,-10%)

 

[Dave Patton]

other ideas

The following consider the True to be generated by formula.
If it is text, put the True in quotes "True".


=IF((A1=TRUE)*(A2="Bull"),10%,-10%)

or
=IF(AND(A1=TRUE,A2="Bull"),10%,-10%)

 

[chaos]

Von Pookie and Dave,

Thanks to both of you! My problem is solved.

All the best,

chaos