Previous Topic Next Topic

Please help it has to be simple for someone

Closed
bgurtz Posts 3 Registration date Tuesday November 24, 2009 Status Member Last seen November 25, 2009 - Nov 24, 2009 at 09:01 PM
bgurtz Posts 3 Registration date Tuesday November 24, 2009 Status Member Last seen November 25, 2009 - Nov 25, 2009 at 03:00 PM
Hello,
I need a Excel Formula
What i need it to do is take information from the A cells and from the B cells and put it into C cells.
Now here is the but for this question. I need it to display text or numbers.
Example
If i have 545 in sell A1 and i have nothing in cell b1 i want it to show 545 in cell C1
If i have the part name in A1 and nothing in cell b1 i want it to display the part name in C1

Now if i have nothing in A1 but the name of the part or a number in B1 i would like it to display in C1

and the last part is if i have information in both A1 and B1 i would like to show the information (text or number) from A1 in C1 ignoring the value in B1.
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 25, 2009 at 05:51 AM
see whether this formula in C1 helps you

=IF(OR(A1="",B1=""),A1&B1,IF(AND(A1<>"",B1<>""),A1))
0
bgurtz Posts 3 Registration date Tuesday November 24, 2009 Status Member Last seen November 25, 2009
Nov 25, 2009 at 03:00 PM
oh wow thanks so much that worked great. i owe you one.
0
Answer 2 / 2
bgurtz Posts 3 Registration date Tuesday November 24, 2009 Status Member Last seen November 25, 2009
Nov 25, 2009 at 02:57 PM
thanks. checking now to see if it works
0

Similar discussions

Phone lock code for gt-e1200y
migs23 -
Computertech -

1 response
samsung Mobile GT-E1200Y unlock code
Madhumita Sengupta -
Ambucias -

1 response
samsung gt-e1200y sim unlock
BADRUZZAMA -
Computertech -

1 response
E1200Y sim lock password
MD NASIR -
Ambucias -

1 response
samsung model GT-E1200 is on lock
donatus -
Ambucias -

1 response