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

G

Guest

How can I set up a formula in Excel to perform only if the value in a cell is
greater than zero?
 
G

Guest

Something like this:

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

Replace yourformula with whatever calculation you need.

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count the number of rows with entries greater than zero 1
COUNTIF for 2 columns 6
Show zero values in specific area 4
Mulitple "IF/OR" statments 3
IF function, nested with 2 source cells? 5
Set Outlook 365 Reminders 2
last value "greater than zero" in a range 3
Increment by 18 1

Top