View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
StumpedAgain StumpedAgain is offline
external usenet poster
 
Posts: 192
Default 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