How can I combine two formulas?
AlanSidman Well-Known Member Apr 20, 2024 #2 More information. Details of what you are trying to do. Your request is too vague to respond. We need details. We are not mind readers.
More information. Details of what you are trying to do. Your request is too vague to respond. We need details. We are not mind readers.
AliGW Active Member Apr 20, 2024 #3 Yes - too vague, but ... Let's assume that A1 contains 1 and I want B1 to add A1 to 10 but if A1 contains 2 I want B1 to multiply A1 by 10. Formulae for B1: =A1+10 =A1*10 Combined: =IF(A1=1,A1+10,IF(A1=2,A1*10,"N/A"))
Yes - too vague, but ... Let's assume that A1 contains 1 and I want B1 to add A1 to 10 but if A1 contains 2 I want B1 to multiply A1 by 10. Formulae for B1: =A1+10 =A1*10 Combined: =IF(A1=1,A1+10,IF(A1=2,A1*10,"N/A"))
