mardi 25 septembre 2018

Value from an IF Statement then SUM Excel

hopefully this is a quick fix.

I have two columns of data, column A1 already populated and column B2, which will be populated ad hoc, then based on whether there is data in either cell, carry out a calculation (E3*D3)then multiplied by the value of the cell either A1 or B2.

So I am fine with the basic IF statements below, and can combine them using IF(OR, but I am stuck using an IF to look at B2 is it greater or less than A1, but doesn't equal 0, then use that value as part of a multiplication (E3*D3)*value ? Is this possible?

Examples

=IF(B3=0,(SUM(E3*D3)*A3))
=IF(B2=A2,(SUM(E2*D2)*B2))

Excel Example

I hope I have made some form of sense, any help will be greatly appreciated.

Cheers

Aucun commentaire:

Enregistrer un commentaire