Copying the contents of a cell to a different sheet but only if it is > zero

J

johno68

I know how to make information automaticaly transfer to a differen
sheet, but how would I add an "if" statement to the formul
"=+sheet1!E5" if I only want #'s greater than zero to transfer
 
E

ElsiePOA

I assume your "=+sheet1!E5" formula is on the sheet you want t
information to transfer to. Change your formula to:
=IF(Sheet1!E5=>0,Sheet1!E5,"")
That will give you E5 from sheet 1 if it is >0 and a blank cell if i
isn'
 
A

Alan

=IF(Sheet1!E5>0,Sheet1!E5,"")
that is to say
IF(Sheet1!E5 is greater than zero then return Sheet!1E5, Otherwise return
"", 0, or any other message you want eg "Greater than zero")
Regards,
 

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

Need Help with a VBA subroutine 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Macro to add new sheet and then fill formula in a totals sheet to refernce this sheet 1
Copy condtional formatting in XL2007 for Windows 1
Average from three different coworkers excluding zeros formula? 3
Copy unformatted value of cell via macro 0
Code to format cells on several worksheets 2
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0

Top