Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 formulas
Good morning,
is it possible to have 2 different formulas in one cell, and if so, how do I go about keeping seperate, thx advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 formulas
You could convert your formula results to text and concatenate them together.
=TEXT(SUM(A1:A33),"#,##0.00")&" - "&TEXT(AVERAGE(B1:B33),"#,##0.00") Look up the TEXT formula in Excel help for list of available formatting masks. -- Kevin Backmann "Roy" wrote: Good morning, is it possible to have 2 different formulas in one cell, and if so, how do I go about keeping seperate, thx advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 formulas
Hi Roy,
What are you trying to achieve? -- Kind regards, Niek Otten Microsoft MVP - Excel "Roy" wrote in message ... | Good morning, | is it possible to have 2 different formulas in one cell, and if so, how do I | go about keeping seperate, thx advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 formulas
hi Roy,
you can embeded functions or use if to have two different actions. eg. =if(a1=10,formula,other_formula) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Roy" escreveu: Good morning, is it possible to have 2 different formulas in one cell, and if so, how do I go about keeping seperate, thx advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 formulas
You can have two formulae but only when one is dependent on the other. For
instance you can have an IF, THEN, ELSE scenario (Who remembers Basic?). Formulae writing is a bit of an art. Perhaps you could outline what you are trying to achieve for someone to be able to help you better. Regards. Bill Ridgeway Computer Solutions "Roy" wrote in message ... Good morning, is it possible to have 2 different formulas in one cell, and if so, how do I go about keeping seperate, thx advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |