Forum Discussion
Solved
If formula
Dear Sirs …. Kindly need your help with below table to distinguish between + or - numbers in the result cell to take + value cell keep in mind the following If formula used in result cell ( if there...
Alternative
= LET( s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))), VSTACK(s, SUM(s)) )
Yousef70 Excel isn't very good at calculating based on colors. That would require VBA which is not my cup of tea.
Dear Riny …
I understand you my friend , I like your expression " not my cup of tea " may I use it
What is VBA though ?
I understand you my friend , I like your expression " not my cup of tea " may I use it
What is VBA though ?
Yousef70 Use that expression as you please. It's not mine 🙂
VBA = Visual Basic for Applications. In short, a programming language used in Excel to automate all sorts of processes that otherwise can't be achieved by regular formulas.