Hi I need a formula that will calculate the total of

– all in column C * £35

– all in Column D * £35

– all in Column E where there is a number, ((multiplied by the figure in Colum B) multiplied by 0.1))

A | B | C | D | E |

70 | ||||

Day 1 | ||||

Fri 24 Mar | ||||

B/T | M/P | O/T | ||

Employee 1 | 250 | 1 | 1 | |

Employee 2 | 250 | 2 | 1 | 1 |

Employee 3 | 350 | |||

Employee 4 | 233 | |||

Employee 5 | 196 |

By: Hussain