Help with if formula for entire column

[kingsnipes]

So I need a formula for the following...

I need AC4:AC40 to -1 from C4:C40 IF U4:U40 >= AC3

any help would be great... thanks

[etaf]

=IF(U4>=$AC$3, C4-1, "what to do if U4 is not >-AC3 , if you just want to put C4 then C4")
that should do it - copy down
in AC4 put
=IF(U4>=$AC$3, C4-1, C4)

[FDibbins]

Hi and welcome to the forum

We would love to help you further with your question, but 1st, in accordance with forum rule, please rename your thread to something more meaningful, that actually describes your problem.

Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

Also, many members will look at a thread title, and if it is of interest to them, or it falls within their area of expertese, they might only open those threads.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

[kingsnipes]

so there isn't a way to set up the formula for the entire column...? I have to put this formula into each box?

[etaf]

yes, you need to copy down, otherwise, you will need to use VBA macro - not be expertise i'm afraid

[FDibbins]

To copy the formula down, just double-click on the small dark box on the bottom right of the cell, it will copy down until it gets to an empty cell on the left

[kingsnipes]

thanks worked perfect... just need to figure out how to change the thread to solved

[FDibbins]

Happy to help