in the attached Sheet, my requirement is:-

If Column C= Cash Sales then put the Text as per Column E but Column C <>(Not Equal to) Cash sales then put the text as per C Column as it is using Formula not by Copy & Paste.

To achieve this task in Excel, you can use the IF function combined with an equality check. The formula you'll use should be entered into the cell where you want the result to appear, and it will look something like this:

=IF(C1="Cash Sales", E1, C1)

Here's a breakdown of this formula:

IF: This is the Excel function for making a conditional decision.

C1="Cash Sales": This is the condition being checked. It tests whether the text in cell C1 is exactly "Cash Sales".

E1: This is the value that will be displayed if the condition is true – that is, if cell C1 contains "Cash Sales".

C1: This is the value that will be displayed if the condition is false – that is, if cell C1 does not contain "Cash Sales".

in which Cell did u put formula??

it is not working......

this was i alredy used.