2 formula 1 cell

[BluTs]

How can I add 2 differents formula in only one cell?

[Nick Hodge]

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
[email protected]HIS


"BluTs" <[email protected]> wrote in message
news:[email protected]...
> How can I add 2 differents formula in only one cell?

[wdjsxj]

use if function

“BluTs”编写：

> How can I add 2 differents formula in only one cell?

[Nick Hodge]

You just nest them

=IF(A1=1,B2,IF(A1=2,B3,0))

You might also like to use OR and AND to check for multiple criteria to
return True or False

Beware, currently, until XL2007, you are limited to 7 nested IFs

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


"wdjsxj" <[email protected]> wrote in message
news:[email protected]...
> use if function
>
> "BluTs"??:
>
>> How can I add 2 differents formula in only one cell?

[BluTs]

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
> [email protected]HIS
>
>
> "BluTs" <[email protected]> wrote in message
> news:[email protected]...
> > How can I add 2 differents formula in only one cell?
>
>
>

[Bearacade]

assuming the hours they work is in d4

=IF(d4=0, 0, IF(d4<=5, 0.5, IF(d4>5, 1)))

[Nick Hodge]

It's a little clouded by the times and whether you have entered them as true
times (5:00 for 5 hours) or just numbers (5)


Presuming the 'number' 5 in A1 then the formula would be say in B1

=IF(A1="","",IF(A1=0,0,IF(A1>5,1,.5)))
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"BluTs" <[email protected]> wrote in message
news:[email protected]...
> 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
>> [email protected]HIS
>>
>>
>> "BluTs" <[email protected]> wrote in message
>> news:[email protected]...
>> > How can I add 2 differents formula in only one cell?
>>
>>
>>