A
Arvi Laanemets
Hi
=IF(TrueCondition,Expression1,Expression2)
Like
=IF(X1="","",SUM(A:A))
Arvi Laanemets
=IF(TrueCondition,Expression1,Expression2)
Like
=IF(X1="","",SUM(A:A))
Arvi Laanemets
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.
G
Gaurav
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.
=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.
P
Peo Sjoblom
=IF(A2>0,"",percentage_formula)
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
G
Gaurav
Sorry it would be
=if(B2>0,"",B2/A2)
=if(B2>0,"",B2/A2)
Gaurav said: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.
C
cgroninger
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.
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.