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

Average from three different coworkers excluding zeros formula? 3
Still having VBA problems 1
auto creating an idex sheet when adding formatted sheets 15
linking cells to other sheets within a workbook 1
Cell problem - cell displays formula instead of value 5
Calculate data from different sheets 4
Highlight MAX Cell Greater Than Zero 4
Ignore zero in column for subtotal 3

Top