Thread: Ex2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Ex2003

Hi,

That would create a circular reference, you need to carry out the
calculation in a different cell like this

=IF(F38="","",E37-E38)

Mike

"Randall" wrote:

In my previous question perhaps i did not explain my problem fully.
I need to actevate box E38 by entering a no in F38 so that when i enter a
number in box F38 it activates box E38 to deduct box E38 from E37 leaving the
deduted figure in box E38.
Hope this is clearer thank you for all youre help.