Formula Help??

[Jav_uk8]

Hi All,

Hi All,

I need a formula to calculate the following in column D (example of returned info in there):

Only bring across the cost (Col C) info from Red (Col A) that is more than £5.00, all others show 0 inc Red, Blue and Green.

I need it for a summary at the bottom (if possible) or could assign to each column D, which I could SUM at the bottom.

Hope this makes sense?

	A	B	C	D
1	Red		£2.29	£2.29
2	Blue		£5.14	£0
3	Blue		£1.01	£0
4	Red		£5.85	£5.85
5	Green		£10.47	£0
6	Red		£9.05	£9.05

<tbody>
</tbody>

Cheers

 

[Special-K99]

in D1
=IF(C1>5,C1,0)
and copy down column D

 

[jmacleary]

Sorry special, I think youve misinterpreted the request. The formula needed I think is =IF(AND(A1="Red",C1>5),C1,0) - but that would only be right if the value in D1 was supposed to be 0.

 

[Jav_uk8]

Hi Special-K99,

Your formula returns the correct value but I only need the formula to return >£5.00 for Reds only.

 

[Jav_uk8]

Hi All,

Thanks for your replies, it has now come to light that I need to show the value from a sum that is >£5.00

Example - Sum of £5.05 (Col C) MINUS £5.00 (Col E), which returns the value of £0.05. Again only applying to Reds and the rest showing "0"

 

[Special-K99]

There is no "Column E"

 

[jmacleary]

Try this: =IF(AND(A1="Red",(C1-E1)>5),C1-E1,0)

 

[Jav_uk8]

It works!!!!

Thank you so much - Have a nice weekend all