IF Statement - brain fog!

[chally3]

Good morning everyone, can anyone help please as Im having a Real brain fog day!

My if statement is =IF(G4=E4,F4,IF(G4>E4,SUM(C4-D4*G4))) which is not returning the value expected and I cannot work out where I have gone wrong.

Column info C=price 1, D=price 2,E = sum of qty received 1, F=(price 1 - price 2 * column E) , G=sum of qty received 2
What I am trying to calculate for instance is

IF Column G is equal to Column E return the value in F, IF G is more than E, price 1 - price 2 * sum of qty received 2

Thank you

 

[tyija1995]

Hi,

It might be because you are doing C4 - (D4 * G4), perhaps you want (C4 - D4)*G4 ?

If that is the case then just put an opening bracket before C4 and a closing bracket after D4, like: SUM((C4-D4)*G4)

 

[steve the fish]

There is a principle of mathematics that multiplication and division are done before addition and subtraction so maybe put some brackets around this part:

C4-D4*G4

to become

(C4-D4)*G4

and you dont need the sum.

 

[Trixterz]

Good morning everyone, can anyone help please as Im having a Real brain fog day!

My if statement is =IF(G4=E4,F4,IF(G4>E4,SUM(C4-D4*G4))) which is not returning the value expected and I cannot work out where I have gone wrong.

Column info C=price 1, D=price 2,E = sum of qty received 1, F=(price 1 - price 2 * column E) , G=sum of qty received 2
What I am trying to calculate for instance is

IF Column G is equal to Column E return the value in F, IF G is more than E, price 1 - price 2 * sum of qty received 2

Thank you

=IF(G4=E4,F4,IF(G4>E4,SUM(C4-D4*G4),"what to do if false?"))

 

[chally3]

Thanks all

 

[chally3]

That the one, thank you, definitely suffering brain fog today ! I should have known that for sure, basic maths!