if e1 = f1 then

[Sophie]

Hi What is the correct formula for this statement
if e1 = f1 then true else false in g1

if e1 = f1 then g1 is 1 else g1 is 2



thanks Sophie

 

[Norman Harker]

Hi Sophie!

G1:
=E1=F1

It's an implicit IF formula; you might prefer the easier to
understand:

=IF(E1=F1,TRUE,FALSE)

Second question:

G1:
=IF(E1=F1,1,2)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
enter the following in G1 for the first question:
=E1=F1

for the second one use
=IF(E1=F1,1,2)

or
=1+(E1<>F1)

 

[Lady Layla]

When is the homework/test due?

: Hi What is the correct formula for this statement
: if e1 = f1 then true else false in g1
:
: if e1 = f1 then g1 is 1 else g1 is 2
:
:
:
: thanks Sophie
:
:

 

[Frank Kabel]

When is the homework/test due?

lol
thought that by myself - but you never know. Maybe a complicated
business issue
Frank

 

[Harald Staff]

lol
thought that by myself - but you never know. Maybe a complicated
business issue

We should only assist the ones that are highly paid to know the solutions
themselves, right ? <bg>

Best wishes Harald