Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 formula 1 cell
How can I add 2 differents formula in only one cell?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 formula 1 cell
use if function
€œBluTs€ç¼–写: How can I add 2 differents formula in only one cell? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |