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

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?

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

One try,

In C1:
=IF(A10,A1,IF(B10,B1,""))

Above presumes that you want the same check (0) to apply to B1 as well
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dim" wrote:
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?

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

Hi Dim,

You can do this by using the below formula:

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

Regards,
Soundar.

"dim" wrote:

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?

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

Thankyou very much. Both those methods worked. :-)