Please help me anyone please

[Yodathehamster77]

Hi guys I am trying to write what I thought is a simple equation but it’s proving more difficult than I thought I think possibly because of my formatting.

I’m trying to do a sum as follows:

=IF(E6="Light Bites",SUMIF(I2,">90")-I3*I4,"0")

So essentially I want it to look at i2 and if it is more than 90 to take that number (97) then to minus i3 (90) then to multiply by i4 (13.95), with the formula I have put in I get the result -1158.50 when it should in fact be 97.65 I know its a formatting error but Im a bit of a beginner, any help would be much appreciated. I can see if I do this sum on a calculator it returns -1158.50 but I need to separate the sum so it calculates as follows
97-90=7*13.95=97.65


screenprint.jpg

Thanks Guys

[Beamernsw]

Hi YTH77, try:-

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Yodathehamster77]

Hi YTH77, try:-

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

You solved my problem, thank you so much it was doing my head in.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.