I have a spreadsheet that does various things i.e. calculating and moving calculations from 1 page to another. I am quite new to Excel and am unsure about the last formula I wish to enter.
I have a column in which various amounts appear example (f19-f52) has amounts ranging from 18 to 46 for example. I wish to have in column (h19-h52) any number that is greater than 28 as shown in columns (f19-f52) is this possible and how do I do it. Thanks. i.e in column h I want the formula to copy any number in the above mentioned f19-f52 if it is greater than 28, also I would like the blank cells in column "h" to remain blank and not appear as zero's
Bookmarks