Forum Discussion
AlanP514
3 years agoPost Patron
Condtional calculated column
Hi i have 4 columns A,B,C,D
I need to create new column E That should be the Combination of C&D So E = C&D
and one more condition is there if C Column doesn't have any data, if it is blank it should from the B
ABCD
| JP | Wellbeing | SDA/WB | Vacuum cleaner |
| DE | Wellbeing | C&A | Vacuum cleaner |
| US | Wellbeing | C&A | Accessories |
| US | Wellbeing | C&A | Vacuum cleaner |
| US | Wellbeing | All Others | All Others |
| US | Wellbeing | SDA/WB | Vacuum cleaner |
| US | Wellbeing | All Others | Vacuum cleaner |
| US | Taste | C&A | Water Filtration |
| ES | Wellbeing | C&A | Vacuum cleaner |
| US | Wellbeing | C&A | Air Purifier |
| DE | Wellbeing | All Others | |
| BR | Wellbeing | Accessories | |
| DE | Taste | MDA | Hood |
| BR | Wellbeing | MDA | Refrigerator |
| BR | Wellbeing | MDA | Home Environment |
| DE | Taste | MDA | Dishwasher |
| ES | Taste | C&A | Oven |
| DE | Taste | MDA | Oven |
| IT | Wellbeing | SDA/WB | Iron |
| DE | Care | MDA | Washing & Drying |
| DE | Care | All Others | Washing & Drying |
| ES | Wellbeing | All Others | All Others |
| FR | Taste | MDA | Hob |
| IT | Taste | MDA | Dishwasher |
| DE | Care | C&A | Washing & Drying |
| ES | Care | MDA | Washing & Drying |
| DE | Taste | MDA | Cooktop |
| DE | Taste | MDA | Refrigerator |
| SE | Wellbeing | C&A | Vacuum cleaner |
| IT | Wellbeing | C&A | Vacuum cleaner |
| SE | Wellbeing | SDA/WB | Heaters |
| DE | Taste | MDA | Hob |
| ES | Taste | C&A | Accessories |
| DE | Taste | C&A | Coffee Machine |
| IT | Taste | MDA | Refrigerator |
| DE | Wellbeing | SDA/WB | Vacuum cleaner |
| UK | Taste | SDA/WB | Electric Kettle |
| DE | Taste | C&A | Dishwasher |
| DE | Wellbeing | All Others | Foot Care |
| SE | Wellbeing | SDA/WB | Vacuum cleaner |
| UK | Taste | SDA/WB | Toaster |
| UK | Taste | SDA/WB | Coffee Machine |
| UK | Care | MDA | Washing & Drying |
| ES | Wellbeing | C&A | Air Purifier |
| DE | Wellbeing | C&A | Iron |
| DE | Wellbeing | C&A | Coffee Machine |
| ES | Taste | C&A | Food Processor |
| DE | Taste | C&A | Food Processor |
| DE | Care | C&A | Air Cooler |
| IT | Taste | MDA | Hood |
| DE | Taste | C&A | Hob |
| ES | Taste | MDA | Oven |
| IT | Taste | MDA | Oven |
| IT | Taste | C&A | Hood |
| ES | Care | C&A | Washing & Drying |
| IT | Care | MDA | Washing & Drying |
| DE | Taste | C&A | Oven |
| DE | Taste | SDA/WB | Blenders |
| DE | Wellbeing | SDA/WB | Air Purifier |
| DE | Wellbeing | SDA/WB | Iron |
| DE | Taste | SDA/WB | Coffee Machine |
| DE | Taste | SDA/WB | Electric Kettle |
| DE | Wellbeing | SDA/WB | Electric Kettle |
| ES | Taste | SDA/WB | Food Processor |
| IT | Wellbeing | SDA/WB | Vacuum cleaner |
| DE | Taste | C&A | Refrigerator |
| ES | Taste | MDA | Dishwasher |
| ES | Taste | C&A | Hob |
| ES | Taste | MDA | Hob |
| ES | Wellbeing | SDA/WB | Vacuum cleaner |
| UK | Wellbeing | C&A | Vacuum cleaner |
| ES | Wellbeing | C&A | Accessories |
| ES | Wellbeing | C&A | Iron |
| ES | Taste | SDA/WB | Blenders |
| DE | Wellbeing | C&A | Air Purifier |
| UK | Wellbeing | SDA/WB | Vacuum cleaner |
| SE | Wellbeing | C&A | Air Purifier |
| UK | Taste | SDA/WB | Blenders |
| IT | Wellbeing | C&A | Iron |
| DE | Taste | SDA/WB | Air Fryer |
| UK | Taste | MDA | Refrigerator |
| DE | Taste | C&A | Accessories |
| IT | Taste | C&A | Coffee Machine |
| DE | Taste | C&A | Blenders |
| ES | Taste | C&A | Blenders |
| DE | Taste | SDA/WB | Toaster |
| ES | Taste | SDA/WB | Toaster |
| UK | Wellbeing | SDA/WB | Toaster |
| ES | Wellbeing | SDA/WB | Iron |
| IT | Taste | All Others | Refrigerator |
| DE | Care | C&A | Water Jug |
| DE | Wellbeing | C&A | Water Filtration |
| DE | Wellbeing | C&A | Water Jug |
| DE | Wellbeing | C&A | Accessories |
| UK | Wellbeing | SDA/WB | Air Purifier |
| ES | Taste | All Others | Oven |
| ES | Taste | SDA/WB | Oven |
| ES | Taste | SDA/WB | Coffee Machine |
| DE | Taste | MDA | Coffee Machine |
| UK | Wellbeing | SDA/WB | Iron |
Hi AlanP514 ,
I hope the below image helpful for your query,
Thanks,
Ajith_Kumar
If I answered your question then mark my post as a solution and a kudo would be appreciated.
2 Replies
- AhmedxSuper User
if (ISBLANK([C]),[B], [C]&[D]) OR if (ISBLANK([C]),[B]&[D], [C]&[D]) - Ajith_KumarFrequent Visitor
Hi AlanP514 ,
I hope the below image helpful for your query,
Thanks,
Ajith_Kumar
If I answered your question then mark my post as a solution and a kudo would be appreciated.