Can a formula be automatically added to a cell(s) when a specific cell exceeds a set number?

Hello and welcome to ExpertHelp.com! My name is Julius San Juan and I'm going to do everything in my power to answer your question to your full satisfaction!

I’m available to chat now. Please let me know that you are ready by posting a response. I’ll leave my chat session open for the next 15 minutes or so and wait for your reply. If I don’t catch you this time, please respond with a few times (including your timezone) that work best for you and we can connect then.

Before we get started, I want to remind you ExpertHelp.com is an independent professional support company. We do not have any affiliation with Microsoft nor are we paid to provide support on their behalf. However, we have helped hundreds of customers with similar questions and believe we can help you too. OK, let’s get started! :)

 Hi Danny,

May you please send me a screenshot of the spreadsheet?

Where do you want to add the formula?

Who will use the spreadsheet? Is it going to be sent out to several users?

That is all for now. These questions will help me to better understand your requirement.

Kind regards,

Julius

There are several ways of solving your problem.

One way is to add these formulas :

On Cell ND25

                    =if(N23>91,0,"")

On Cells ND30, ND31, ND32

                   =if(N23>91,***Enter your formula here without the equal sign***. "")

 you can just replace the "" with the values that you want be on cells if the N23 is less than 92.

Another way to tackle it is  to use "custom functions" and/or "Macros". This requires coding and you have to enable Macros on Excel. Also, for me to apply this solution I will have to get a copy of your worksheet (you can input dummy figures), I just need to see which cells/formulas are going to be affected.