| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple functions in one cell
Is there a way to write a formula that will leave a cell blank if a specified value is a positive number, but will calculate a percentage if the value is a negative number? I know how to write these formulas separately, but cannot seem to get it right bringing them together in one cell. Not sure if this is even possible. -- cgroninger |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple functions in one cell
Something like
=if(B2="","",B2/A2) the details you gave were only good to make assumptions. If this is not what you want, post back with more details. "cgroninger" wrote in message ... Is there a way to write a formula that will leave a cell blank if a specified value is a positive number, but will calculate a percentage if the value is a negative number? I know how to write these formulas separately, but cannot seem to get it right bringing them together in one cell. Not sure if this is even possible. -- cgroninger |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple functions in one cell
Sorry it would be
=if(B20,"",B2/A2) "Gaurav" wrote in message ... Something like =if(B2="","",B2/A2) the details you gave were only good to make assumptions. If this is not what you want, post back with more details. "cgroninger" wrote in message ... Is there a way to write a formula that will leave a cell blank if a specified value is a positive number, but will calculate a percentage if the value is a negative number? I know how to write these formulas separately, but cannot seem to get it right bringing them together in one cell. Not sure if this is even possible. -- cgroninger |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple functions in one cell
Hi
=IF(TrueCondition,Expression1,Expression2) Like =IF(X1="","",SUM(A:A)) Arvi Laanemets "cgroninger" wrote in message ... Is there a way to write a formula that will leave a cell blank if a specified value is a positive number, but will calculate a percentage if the value is a negative number? I know how to write these formulas separately, but cannot seem to get it right bringing them together in one cell. Not sure if this is even possible. -- cgroninger |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple functions in one cell
=IF(A20,"",percentage_formula)
-- Regards, Peo Sjoblom "cgroninger" wrote in message ... Is there a way to write a formula that will leave a cell blank if a specified value is a positive number, but will calculate a percentage if the value is a negative number? I know how to write these formulas separately, but cannot seem to get it right bringing them together in one cell. Not sure if this is even possible. -- cgroninger |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple functions on one cell ? | Excel Discussion (Misc queries) | |||
| Multiple functions in a cell help | New Users to Excel | |||
| MUltiple functions on a same cell | Excel Discussion (Misc queries) | |||
| Multiple functions per cell? | Excel Worksheet Functions | |||
| Multiple functions in one cell | Excel Worksheet Functions | |||
Hybrid Mode
