Conditional formulae

New Contributor


Please excuse my ignorance but I am struggling to find an appropriate formula for a cashflow spreadsheet. I want to add a formula to automate the following scenario:


If the value in cell T2 <200000, take 100000 from value in U3 and add 100000 to value in T3


I would really appreciate any advice.

Many thanks,


2 Replies
best response confirmed by allyreckerman (Microsoft)


If you mean decrease current value in U3 and increase existing value in T3 based on some condition - that's VBA programming, not formulae. Or you mean another logic?

@Sergei Baklan Thank you very much for your helpful response Sergei.  Yes, you have interpreted my question correctly.  I am not at all familiar with VBA programming so I will do some research.