Conditional formulae

New Contributor

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 Replies

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

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