Feb 16 2020 02:56 AM
Hello
Can someone help me
See Attached file
Best regards Svein Tore (NOR)
Thank's in advance
Feb 16 2020 03:11 AM
Feb 16 2020 09:15 AM
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 )