View Single Post
  #1   Report Post  
Brett Patterson
 
Posts: n/a
Default Format Column with Same Function

Hey guys.

I'm trying to format all the cells in column G with the following function:
=E2-F2

How would I format the column so that when data is entered into E2 & F2, G2
would automatically update with the value?

I have tried
=$E2-$F2
and
=E$2-F$2

Both don't work. Any help would be greatly appreciated.
------------------------
Brett Patterson
UMBC EHS Management Major