Excel Sum

chipperhead · 29 Sep 2006 at 21:55

I'd really appreciate it if someone could help me out with a sum that I can paste into an excel spread sheet.

I have designed a spread sheet that you enter the quanity into each product and it gives you a total price for that number of products.

I then need it to add each individual sum and give me a total sum, this bit i can do but I then need it so that if the sum is less than £150 it adds £10 on, over this amount, nothing gets added on.

Thanks.

shine · 29 Sep 2006 at 22:01

Using a IF function it should look something like this:

=IF(C7<150;C7+10)

where C7 is the cell that holds your total price.

chipperhead · 29 Sep 2006 at 22:05

Thanks, thats something along the lines of what I was trying for, the only thing now is if it over £150 it now says False

shine · 29 Sep 2006 at 22:06

My mistake - cut and paste error:

=IF(C7<150;C7+10;C7)

That will do it.

chipperhead · 29 Sep 2006 at 22:10

Thanks for your help shine I think I've got it now,
I'm sure this works, =IF(D12<150,D12+10,D12+0), just testing it out now.

chipperhead · 29 Sep 2006 at 22:26

Much appreciated, just noticed your reply while I typed mine out, I'd put into mine D12+0 at the end which I've obviously now realised after reading yours I don't need the +0

Thanks for that you've been a great help

shine · 29 Sep 2006 at 22:31

Glad I could be of assistance.