If formula

[Johnboy28]

Hi,

I'm require a formula to deduct available from total required. If the value is greater than Option 2, then it will equal the value of Option 2?

Thanks for any help.

Total Required	Available	Option 2	Total Sum	Answer
293	85	164	??	164
293	157	218		136
329	109	183		183
329	111	99		99
384	100	44		44
366	111	115		115
329	117	54		54
366	132	71		71

<tbody>
</tbody>

 

[Fluff]

How about

Excel 2013 32 bit
	A	B	C	D	E
1	Total Required	Available	Option 2	Total Sum	Answer
2	293	85	164	164	164
3	293	157	218	136	136
4	329	109	183	183	183
5	329	111	99	99	99
6	384	100	44	44	44
7	366	111	115	115	115
8	329	117	54	54	54
9	366	132	71	71	71
Week38

Cell Formulas
Range	Formula
D2	=IF(A2-B2>C2,C2,A2-B2)

 

[Johnboy28]

Thanks for your help. That works great.

 

[Fluff]

Glad to help & thanks for the feedback

 

[jtakw]

Hi,

You can also do this:

Book1
	A	B	C	D
1	Total Required	Available	Option 2	Total Sum
2	293	85	164	164
3	293	157	218	136
4	329	109	183	183
5	329	111	99	99
6	384	100	44	44
7	366	111	115	115
8	329	117	54	54
9	366	132	71	71
Sheet224

Cell Formulas
Range	Formula
D2	=MIN(A2-B2,C2)

 

[Johnboy28]

Thank you. Will try this.

 

[jtakw]

You're welcome.