Software

Ask something
Question Locked

Help in Excel - if then function

0 helpful
2 replies

by sandeepuc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

Can you help me with a "If - then function"

What I need is

"IF A1 is not = B1, then A1 is replaced by B1 , else contents in A1
remain in A1"

Kindly assist me in fixing this function / formula in excel ...

2 replies

by thumbsup2

This sounds like a homework assignment. Do you not understand the HELP built into Excel functions?

Let us see what you've tried so far and tell us what cell you've put it in. We'll give you an indication of where you're going wrong.

(Hint: If you replace the contents of cell A1 when the formula is executed the first time, the formula then becomes false.)

This discussion is closed to new replies.