Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to perform calcutions only if value if greater than zero?

0 views
Skip to first unread message

barbaraatm

unread,
May 26, 2006, 1:24:02 PM5/26/06
to
How can I set up a formula in Excel to perform only if the value in a cell is
greater than zero?

Elkar

unread,
May 26, 2006, 1:37:02 PM5/26/06
to
Something like this:

=IF(A1>0,yourformula,"")

Replace yourformula with whatever calculation you need.

HTH,
Elkar

0 new messages