Conditional formulae

[Alan_Fowler_65]

Hi,

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,

Alan

[#2 · Accepted solution]

@Alan_Fowler_65 

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?

[#3]

@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.