Ques. about sheet reference in a forumla

This is a discussion on Ques. about sheet reference in a forumla within the Spreadsheets forums in Other Technologies category; 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 ...

Go Back   Database Forum > Other Technologies > Spreadsheets

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 06-02-2008, 09:45 PM
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 02:57 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.