Logical Operators upgrade.

Hi there... nested IF's are great but can we have something a little more elegant?

1. Can we allow for AND, OR operators in IF statements?

eg:

IF(1>0 AND 2>2,10,-10) retursn -10

2. Can we have CASE statements?

eg:

CASE(
X=1;100;
X=2;200;
)

hi

IF(1>0 AND 2>2,10,-10) retursn -10

try IF(AND(1>0,2>2),10,-10)


mcbee

Did not know this.

Add it as an example to the help manual!

hi
it is basic excel formulea.

mcbee

OK great..! Add THAT to the manual too! Even better.

.....and I see THAT is already in the manual...Jolly good carry on as you were!