Cable Forum - View Single Post

Nemesis · 19-04-2005, 10:10

Do the calculation in a different cell ... then

use If ... then referencing that cell to check is it's lower than 500, if so set your cell to 500, if not use the cell you did the calculation in.

=IF(A1<500,500,A1)

A1 being the cell you did the calculation in

19-04-2005, 10:10	#2
Nemesis Inactive Join Date: Jun 2003 Location: Surrey Age: 59 Services: Virgin stuff Posts: 6,407	Re: Excel help please Do the calculation in a different cell ... then use If ... then referencing that cell to check is it's lower than 500, if so set your cell to 500, if not use the cell you did the calculation in. =IF(A1<500,500,A1) A1 being the cell you did the calculation in