Thread: Formula Based on the cell its in
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBoyer JBoyer is offline
external usenet poster
  
Posts: 72
Default Formula Based on the cell its in
If I have a formula in a cell can base its content off that cell. What I mean
is say in E2 i have the following equation =IF(SUM(F6:L6)0,SUM(F6:L6),""). I
want to fomat it so it would be something like0=IF(SUM((F[CELL
LOCATION+4]:L[CELL LOCATION+4])0,SUM(F[CELL LOCATION+4]:L[CELL
LOCATION+4]),""). I know this is a correction function, but I just want to
explain what I mean
Reply With QuoteReply With Quote