Link to home
Start Free TrialLog in
Avatar of swjtx99
swjtx99

asked on

Return value from a column unless that value is null, then return value from another column.

This is probably a simple problem but all I need is a formula to return an value from column B unless B is null, then return the value in column A.

Example:

A        B          c
22      20        20 <value to return in C
13      0           0
64     null      64
64     72         72
null   14        14
SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Now the question for clarification:

Does the cell contain the text "null" or is the cell blank?
Hi teylyn, I very much doubt that the word 'null' is really there.

I'm fairly sure swjtx99 wants the word null to represent a blank cell
Avatar of swjtx99
swjtx99

ASKER

Hi,

You are correct Eirman, it's just a blank cell. I specifically go in and do a "clear contents" so I'm sure there is nothing in that cell. My understanding was that would give you a "null" value?

As there was that point of mis-clarity would it be fair to split the points?

Thank you both,

I appreciate the help!

swjtx99
Avatar of swjtx99

ASKER

Grateful to get the help!
Thanks swjtx99.
There are subtle (and confusing) differences between null and blank as this post illustrates ....

https://www.experts-exchange.com/questions/20978027/the-real-difference-between-isblank-isempty-and-null.html