If or

[1troy123]

Hi,

I'm trying to write a formula that does something similar to the following, is this possible and how?

=IF(a1>0 OR B1>0, [value_if_true],[value_if_false]

thanks 1troy123

[Glenn Kennedy]

Try this and let me know.

Please Login or Register  to view this content.

[Ace_XL]

=IF(OR(a1>0,B1>0),[value_if_true],[value_if_false])

[1troy123]

this works a treat thank you!!