conditional cell formula
 

I am trying to set up a formula that has conditions for one cell only -- It
is on a timesheet and it's for call in pay difference -- I want it to give me
the contents of a cell --example B25, if B25 is 4,0 and <0,0 I only want the
results if the contents in the cell is <4 and 0--I know there has to be a
way to acheive this--
--
Thanks so much--Paula

conditional cell formula
 

=IF(OR(B254,B25<0),0,B25)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Paula" wrote in message
...
I am trying to set up a formula that has conditions for one cell only -- It
is on a timesheet and it's for call in pay difference -- I want it to give
me
the contents of a cell --example B25, if B25 is 4,0 and <0,0 I only want
the
results if the contents in the cell is <4 and 0--I know there has to be a
way to acheive this--
--
Thanks so much--Paula

conditional cell formula
 

=IF(B25<4,IF(B250,B25,0),0)

How's that?
--
-SA


"Paula" wrote:

I am trying to set up a formula that has conditions for one cell only -- It
is on a timesheet and it's for call in pay difference -- I want it to give me
the contents of a cell --example B25, if B25 is 4,0 and <0,0 I only want the
results if the contents in the cell is <4 and 0--I know there has to be a
way to acheive this--
--
Thanks so much--Paula