Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet 2 name is "BTB_TACTIMESHT_578162"
Hello from Steved
I would like to use the name "BTB_TACTIMESHT_578162" how do I acheive this please, in the below formula. Sheet 1 the formula is =IF(OR(F1="A",E1=12),(INT(E1)*60)+((E1-INT(E1))*100),(INT(E1)*60)+((E1-INT(E1))*100)+720) Sheet 2 name is Sheet 2 name is "BTB_TACTIMESHT_578162" Thankyou. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet 2 name is "BTB_TACTIMESHT_578162"
Hi!
Don't'cha just love those long sheet names? <VVBG Temporarily rename sheet BTB_TACTIMESHT_578162 to 1. (or X or something really short) Edit your formula to reference the new temporary sheet name: =IF(OR('1'!F1="A",'1'!E1=12),(INT('1'!E1)*60)+((' 1'!E1-INT('1'!E1))*100),(INT('1'!E1)*60)+(('1'!E1-INT('1'!E1))*100)+720) Change the sheet name from 1 back to BTB_TACTIMESHT_578162. Just look at how long that formula is with that long sheet name. Hint, hint <g Biff "Steved" wrote in message ... Hello from Steved I would like to use the name "BTB_TACTIMESHT_578162" how do I acheive this please, in the below formula. Sheet 1 the formula is =IF(OR(F1="A",E1=12),(INT(E1)*60)+((E1-INT(E1))*100),(INT(E1)*60)+((E1-INT(E1))*100)+720) Sheet 2 name is Sheet 2 name is "BTB_TACTIMESHT_578162" Thankyou. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet 2 name is "BTB_TACTIMESHT_578162"
Thanks Biff
"Biff" wrote: Hi! Don't'cha just love those long sheet names? <VVBG Temporarily rename sheet BTB_TACTIMESHT_578162 to 1. (or X or something really short) Edit your formula to reference the new temporary sheet name: =IF(OR('1'!F1="A",'1'!E1=12),(INT('1'!E1)*60)+((' 1'!E1-INT('1'!E1))*100),(INT('1'!E1)*60)+(('1'!E1-INT('1'!E1))*100)+720) Change the sheet name from 1 back to BTB_TACTIMESHT_578162. Just look at how long that formula is with that long sheet name. Hint, hint <g Biff "Steved" wrote in message ... Hello from Steved I would like to use the name "BTB_TACTIMESHT_578162" how do I acheive this please, in the below formula. Sheet 1 the formula is =IF(OR(F1="A",E1=12),(INT(E1)*60)+((E1-INT(E1))*100),(INT(E1)*60)+((E1-INT(E1))*100)+720) Sheet 2 name is Sheet 2 name is "BTB_TACTIMESHT_578162" Thankyou. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet 2 name is "BTB_TACTIMESHT_578162"
Hi
At start, simplify youf formula somewhat: =INT(E1)*60+(E1-INT(E1))*100+720*AND(F1<"A",E1<12) For second, my advice is never to use long sheet names (additionally to Biff's reasoning, it makes difficult to switch between sheet tabs, as you have less of them visible), and also avoid sheet names which contain spaces (no case here lukily). At last, when for some reason you don't want to opt Biff's solution, then there is another way: Select the cell, to where you want to enter the formula; Create short named range(s), like rng1=BTB_TACTIMESHT_578162!$E1 rng2=BTB_TACTIMESHT_578162!$F1 (Here I assumed that both cells you are referring to are situated on another sheet, and that you'll copy your formula down. When otherwise, then you'll need to make some changes. And range names gan be something meaningfull of-course) The formula will now be: =INT(rng1)*60+(rng1-INT(rng1))*100+720*AND(rng2<"A",rng1<12) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Steved" wrote in message ... Hello from Steved I would like to use the name "BTB_TACTIMESHT_578162" how do I acheive this please, in the below formula. Sheet 1 the formula is =IF(OR(F1="A",E1=12),(INT(E1)*60)+((E1-INT(E1))*100),(INT(E1)*60)+((E1-INT(E1))*100)+720) Sheet 2 name is Sheet 2 name is "BTB_TACTIMESHT_578162" Thankyou. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet 2 name is "BTB_TACTIMESHT_578162"
Hello Arvi from Steved
Thankyou. "Arvi Laanemets" wrote: Hi At start, simplify youf formula somewhat: =INT(E1)*60+(E1-INT(E1))*100+720*AND(F1<"A",E1<12) For second, my advice is never to use long sheet names (additionally to Biff's reasoning, it makes difficult to switch between sheet tabs, as you have less of them visible), and also avoid sheet names which contain spaces (no case here lukily). At last, when for some reason you don't want to opt Biff's solution, then there is another way: Select the cell, to where you want to enter the formula; Create short named range(s), like rng1=BTB_TACTIMESHT_578162!$E1 rng2=BTB_TACTIMESHT_578162!$F1 (Here I assumed that both cells you are referring to are situated on another sheet, and that you'll copy your formula down. When otherwise, then you'll need to make some changes. And range names gan be something meaningfull of-course) The formula will now be: =INT(rng1)*60+(rng1-INT(rng1))*100+720*AND(rng2<"A",rng1<12) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Steved" wrote in message ... Hello from Steved I would like to use the name "BTB_TACTIMESHT_578162" how do I acheive this please, in the below formula. Sheet 1 the formula is =IF(OR(F1="A",E1=12),(INT(E1)*60)+((E1-INT(E1))*100),(INT(E1)*60)+((E1-INT(E1))*100)+720) Sheet 2 name is Sheet 2 name is "BTB_TACTIMESHT_578162" Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Daily Totals on a summary sheet | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |