If formula

[koba]

Hi all

I need help with a basic formula

if cell b1>0 or then display b1, otherwise display a1. This bit i
easy, but the chanllange comes when some of the cells in b contain th
word "Leave". How do i add the second bit in the formula

thanks for the help

andre

 

[koba]

if the cell contains the word leave then display a1.

sorry forgot that bit

andre

 

[Dave Peterson]

=if(b1="leave",a1,b1)
???

or maybe...

=if(or(b1>0,b1="Leave"),b1,a1)

 

[Cutter]

I assume you currently have:
=IF(B1>0,B1,A1)

Change it to:
=IF(AND(B1>0,B1<>"Leave"),B1,A1