2 formula 1 cell
 

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

2 formula 1 cell
 

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?

2 formula 1 cell
 

use if function

€œBluTs€�编写：

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

2 formula 1 cell
 

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
HIS


"wdjsxj" wrote in message
...
use if function

"BluTs"??:

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

2 formula 1 cell
 

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?

2 formula 1 cell
 

assuming the hours they work is in d4

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=560558

2 formula 1 cell
 

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(A15,1,.5)))
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"BluTs" wrote in message
...
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?