AND / OR in formulas?

[Elsdro]

Morning all,

It has been a while since I have had to used AND / OR within a function / formula.

Please can anyone help me with the formula below, just cannot get it to work:-

=IF(B23,"ATTENDED"," ")*OR(B24,"REQUESTED"," ")

All assistance gratefully received.

Thanks
Ross

[Andrew-R]

AND and OR are a bit strange in functions, try this...

Please Login or Register  to view this content.

[Elsdro]

Andrew -R - thanks for the help.

I don't think I gave a good explaination, apologies:-

What I have is a control box for a REQUESTED (B24), then a contol box for ATTENDED (B23).

I need to display either REQUESTED or ATTENDED in (D23) based on which control box is selected.

Thanks again

[Andrew-R]

Sorry, what do you mean by "control box"? An example sheet may be the way to go here.

[romperstomper]

Do you mean:
=IF(B23,"ATTENDED",IF(B24,"REQUESTED",""))

[Elsdro]

I have attached an example, your help is much appreciated.

Cheers
Ross

[Elsdro]

Do you mean:
=IF(B23,"ATTENDED",IF(B24,"REQUESTED",""))

Thanks, that has solved the issue.

[teylyn]

Elsdro,

there is no code behind your checkbox. What do you expect to happen? If you use an ActiveX control, you have to write code that does something when the control is clicked.

You may be better off using a check box from the Forms toolbar instead and linking the check box to a cell, which in turn can be evaluated by a formula without any VBA.

[teylyn]

I see that you state your Office version as 2008. Does that mean you are running Office 2008 for Mac? In this case, you won't be able to use VBA at all. So, stay clear of ActiveX controls and use Form controls instead.

[romperstomper]

there is no code behind your checkbox. What do you expect to happen? If you use an ActiveX control, you have to write code that does something when the control is clicked.

Not true, actually - you can just set the LinkedCell property as was done here, but your point about 2008 applies - you can't use ActiveX controls at all there (even without VBA)

[teylyn]

actually - you can just set the LinkedCell property

duhh!! Thanks, romperstomper.