IF ELSE type statement

**Cheekychives** · 05-23-2013, 10:18 AM

My brain has melted and I just can't think anymore...

I'm trying to copy numbers from two fields into one like this: IF Field1 = 0 copy data from Feild2 BUT IF Field1 >0 copy data from Field1

I've tried a few attempts and seem to be failing

Any help much appreciated.

**Fotis1991** · 05-23-2013, 10:22 AM

Perhaps ...

=IF(A1<>0,A1,C1)

A1=field1
C1=field2

**Cheekychives** · 05-23-2013, 10:57 AM

Originally Posted by Fotis1991

Perhaps ...

=IF(A1<>0,A1,C1)

A1=field1
C1=field2

Brilliant.
Many, many, thanks.

**Fotis1991** · 05-23-2013, 10:58 AM

..................

IF ELSE type statement

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

IF ELSE type statement

Re: IF ELSE type statement

Re: IF ELSE type statement

Re: IF ELSE type statement

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions