Hi Folks,
I have two formulas that I would like to write as a single formula
formula 1
=if(AND(A1>8, B1=1),-C1, "SAME TEXT")
Formula 2
=IF(AND(A1>8, B1<>1),C1-6,"SAME TEXT")
Is it possible to write these two formula's as a single formula?
Any help would be much appreciated.
Thank you in advance.
Bookmarks