kmprice710
Board Regular
- Joined
- Jan 8, 2014
- Messages
- 87
- Office Version
- 2019
- Platform
- Windows
I have four columns of pricing data. If columns A, B, C are all blank, then I want to output whatever is in column D. If Columns A & B are blank but something is in C, then I want C. If Columns A & C are blank, but something is in B, then I want B. If Columns B & C are blank but something is in A, then I want A. There's never a case of something being in A & B, A & C or B & C at the same time.
I think I can write this with an IF/THEN using ISBLANK or COUNTBLANK, but how do I nest it?
<tbody>
</tbody>
I think I can write this with an IF/THEN using ISBLANK or COUNTBLANK, but how do I nest it?
5.66 | 3.24 | ||
6.75 | 18.99 | ||
17.15 | |||
7.82 | 22.25 |
<tbody>
</tbody>
Last edited: