B
BluTs
How can I add 2 differents formula in only one cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
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]
nest one within another
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
W
wdjsxj
use if function
“BluTsâ€ç¼–写：
“BluTsâ€ç¼–写：
N
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]
=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]
B
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
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
B
Bearacade
assuming the hours they work is in d4
=IF(d4=0, 0, IF(d4<=5, 0.5, IF(d4>5, 1)))
=IF(d4=0, 0, IF(d4<=5, 0.5, IF(d4>5, 1)))
N
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]
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]