View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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