Multiple cells

Copper Contributor

Hello
Can someone help me
See Attached file

Best regards Svein Tore (NOR)

Thank's in advance

2 Replies
hi I would like to ask you about one of the most important things, how to create an excel linear motion chart in excel such as in physics so that two units create a chart with a right angle and then let it go up if you don't understand me, just type in google chart uniform linear motion

@Svein Tore Kristensen 

Not to show zeroes you may apply custom number format like #,##0.0;;

 

To avoid #DIV/0! you may first check divider if it is zero or not; or wrap formula by IFEEROR as

=IF(B8=1,IFERROR(E8*F8/G8,0),0)
or
=IF(G8=0,0,(B8=1)*E8*F8/G8 )