div/0 question

[JG71]

Hello,
One more question I am linking books together and I cant figure out what I am doing wrong with this equation but it is giving me a div/0 error if there is no value

SUM('M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$F$46)/SUM('M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$B$46/60)

any help would be appreciated

 

[Aladin Akyurek]

=IF('M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$B$46,'M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$F$46/('M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$B$46/60),"")

 

[Brian from Maui]

Hello,
One more question I am linking books together and I cant figure out what I am doing wrong with this equation but it is giving me a div/0 error if there is no value

SUM('M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$F$46)/SUM('M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$B$46/60)

any help would be appreciated

Why Sum? Try,


=IF('M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$B$46,M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$F$46)/'M:\Masters\[Heathrow Productivity-02-04.xls]Heathrow Productivity'!$B$46/60,"")

 

[JG71]

Thanks alot works perfect