dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Ques. about sheet reference in a forumla - Spreadsheets

This is a discussion on Ques. about sheet reference in a forumla - Spreadsheets ; I have question about why would you put a sheet reference in a forumla to have it reference the same sheet the formula is on? Hope I said that right. Heres the formula- =IF($P1.B6="";0;IF(SUM(C6:E6)=0;"--";SUM(C6:E6))) this is the part I'm not ...


Home > Database Forum > Other Technologies > Spreadsheets > Ques. about sheet reference in a forumla

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 06-02-2008, 08:45 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Ques. about sheet reference in a forumla


I have question about why would you put a sheet reference in a forumla to have it reference the same sheet
the formula is on?

Hope I said that right.

Heres the formula-
=IF($P1.B6="";0;IF(SUM(C6:E6)=0;"--";SUM(C6:E6)))

this is the part I'm not sure about $P1.B6
Why would you need the $P1 (which is refering to sheet P1) when the formula is on the same sheet?

when this would work as well
=IF(B6="";0;IF(SUM(C6:E6)=0;"--";SUM(C6:E6)))

would there be a advantage to having the sheet reference?
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 06:35 PM.