Hi

better answer (thanks Bill)
a function can not change the value of another cell - you need to use a VBA
macro for this - for example you could code against the worksheet_change
event that if the cell with the function in it returned a 0 or whatever,
then Range(C3) needs to change to a 1.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Gary's Student" wrote in message
...
I am writing a function to calculate the area of a triangle given the
lengths
of the sides. If the inputs are invalid (one side too big), I want the
function to set CELL(3,3) to one. Setting CELL(3,3)=1 in the function
doesn't work. How can I accomplish this?
--
Gary's Student