well i'm trying somthing for a shedule at work
ex: if they have less then 5 hours they have 0.5h of lunch break if they ave
more then it's 1, then if they have the day off they are gonna be working 0
hours so i want it to do something like if d4=0,"0","0"

I know it's not realy clear but that's what i want to do

Nick Hodge" wrote:

Give us some example of what you are trying to do, but generally you just
nest one within another

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"BluTs" wrote in message
...
How can I add 2 differents formula in only one cell?