ExcelBanter - excel formula syntax

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel formula syntax (https://www.excelbanter.com/excel-worksheet-functions/253124-excel-formula-syntax.html)

Barbara

excel formula syntax

WHAT IS EXCEL SYNATX FOR: IF A2=C1 THEN T2 = S2?

Dave Peterson

excel formula syntax

First, the formula has to go into T2:

=if(a2=c1,s2,"not equal")

replace that "not equal" string with what you want to see if A2 doesn't equal
C1.

Barbara wrote:

WHAT IS EXCEL SYNATX FOR: IF A2=C1 THEN T2 = S2?

--

Dave Peterson

All times are GMT +1. The time now is 12:05 PM.