# I need to create a formula

1. ## I need to create a formula

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

2. ## Re: I need to create a formula

Use this Array formula in column H

=IFERROR(INDEX(\$F\$19:\$F\$52,SMALL(IF(\$F\$19:\$F\$52>28,ROW(\$F\$19:\$F\$52)-18),ROW(F1))),"")

If you really use Excel 2003 replace the iferror formula with if(iserror.

3. ## Re: I need to create a formula

Post this in column H, starting at 19, then drag down as far as desired.

=if(F19 > 28, F19, "")

4. ## Re: I need to create a formula

GeoffTT,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

5. ## Re: I need to create a formula

Originally Posted by Tekkie2412
Post this in column H, starting at 19, then drag down as far as desired.

=if(F19 > 28, F19, "")
Thank you for this, I have entered it and it works like clockwork, again thank you

6. ## Re: I need to create a formula

I am not going to take the trouble of reading to suit you, I have had a difinitive answer without any pedantic comments.

7. ## Re: I need to create a formula

GeoffTT,

The forum rules are in place for every user. How would you feel if you searched for a particular question in the forum and found the thread "Need to create a formula"? Would it give you the slightest hint about what the thread is about? Think about other users who are facing the similar situation as yours. Wouldnt you want to help them out?

8. ## Re: I need to create a formula

Thank you for emphasizing this point. We're here to help one another, not just satisfy our own needs.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1