Formula Help

[CoryMaples]

I am trying to come up with a formula to count how many robot batteries are needed. Below you will see the formula that I am using to input the type of robot battery for that type of robot and multiply the quantity of robots in that column by 4 to come out with how many I need (each robot takes 4 batteries).
The problem that I am having is that I have (2) types of batteries, a C cell battery and a D cell battery. Is there a way to count both types of batteries in once cell so it looks like this 8 C and 2 D Batteries?

 

[Elaszat]

Hi CoryMaples,

you can count both types of batteries in seperate cells and then concatenate them in your desired cell like this:

=CONCATENATE(Cell_with_C_cells," C and ",Cell_with_D_cells," D Batteries")

or simpler:

=Cell_with_C_cells&"C and "&Cell_with_D_cells&" D Batteries"

Both will output

8 C and 2 D Batteries

Regards,
Elaszat