error?

[Carolyn Jones]

Does anyone see what is wrong with this formula?
I don't understand the # signs.


=IF($G6=-1#AND#B7>E6,B7,IF($G6=1,B7,E6))

 

[Norman Harker]

Hi Carolyn!

Excel syntax is:
=IF(AND($G6=-1,B7>E6),B7,IF($G6=1,B7,E6))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

Hi Carolyn,

Try it this way:

=IF(AND($G6=-1,B7>E6),B7,IF($G6=1,B7,E6))

Biff