Google sheets recipe: if a cell has a positive value, use it, else use the value from another column

Posted on by

In the Google sheet shown, there are two columns for Orders and Adjusted orders. Only some of entries have adjusted values, but when they exist, they take precedence. 

Here is the conditional formula that selects which column to use to populate the final column on the right..

=if(AD:AD>0,AD:AD,AA:AA)

=if(AD:AD>0,AD:AD,AA:AA)