How can I combine these two statements into one formula?


=IF(AND(B24=1,C24=10),C24,-5)

=IF(AND(B24=1,C24=-10),C24,"")

Thanks