Can I have a statement like: If - Then - Otherwise ?

[Guest]

I want to say:

If cell A1 value > 0, then copy that value to cell C1, otherwise copy cell
B1 value to cell C1

Can someone make a suggestion please?

 

[Guest]

One try,

In C1:
=IF(A1>0,A1,IF(B1>0,B1,""))

Above presumes that you want the same check (>0) to apply to B1 as well

 

[Guest]

Hi Dim,

You can do this by using the below formula:

=IF(A1>0,A1,B1) ==> Plese give this formula in C1

Regards,
Soundar.

 

[Guest]

Thankyou very much. Both those methods worked.