If statement...does not work!

[rlnye]

Can anyone please help and tell me what's wrong with the following If function.

=IF(H9=2,(I9*2)*H5),IF(H9=3,(I9*3)*H5)

Thanks before hand.

 

[PaddyD]

bracket in the wrong place after the first instance of H5 effectively closing off the iff statement. try:

=IF(H9=2,(I9*2)*H5,IF(H9=3,(I9*3)*H5))

paddy

 

[Tommy Bak]

=IF(H9=2,(I9*2)*H5,IF(H9=3,(I9*3)*H5))
regards tommy

 

[Tommy Bak]

well, i can see that i am too slow for you PaddyB

 

[dantb]

Or maybe
=IF(H9=2,(I9*2)*H5,IF(H9=3,(I9*3)*H5,0))

 

[PaddyD]

On 2002-08-25 17:03, Tommy Bak wrote:
well, i can see that i am too slow for you PaddyB

by less than a second though!

EDIT: & dantb has a good point - you should consider what you wnat to happen if the values are not 2 / 3. If there are more than a few different conditions, you might consider a lookup table.

& one last point - given that if H9 is 2, you're multiplying by 2, & by 3 if it's 3, why not:

=I9*H9*H5
This message was edited by PaddyD on 2002-08-25 17:13