Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding part of a function on condition.
My spreadsheet image is below... http://www.digitaluprising.net/site/...l_untitled.JPG What i'm trying to do is, at present, all my lengths are in feet... but sometimes i need inches... so what i want to do is...make the board foot function add an additional "/12" to my current funtion "=H20*F20*D20/12" when i fill in a lenght as 120" vs 120. Even if i could use a checkbox to add the additional "/12" to my function that would be helpful! Thanks! -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=374028 |
#2
|
|||
|
|||
anyone have any thoughts at all that *might* get the desired results? -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=374028 |
#3
|
|||
|
|||
perhaps even something like if checkbox= clicked cell:b17 = "formula1" and if checkbox= unclicked cell:b17 = "formula2" ?? -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=374028 |
#4
|
|||
|
|||
Lets say you have a checkbox from the forms menu and link it to cell A1. Now when you check the box, cell A1 will have true, and when you uncheck, it will have false. Now to all your formulae which use the length which is entered in inches or feet, you can add this part. then =H20*F20*D20/(if(A1,12,1)) If you check the box, A1 will be true, and your formula will be divided by 12, and if the box is unchecked, then A1 is false, and your formula will be divided by 1. Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=374028 |
#5
|
|||
|
|||
absolutly perfect! Thanks! -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=374028 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
How about adding a quarterly function to Excel like its EOMonth? | Excel Worksheet Functions | |||
Adding text before a function | Excel Worksheet Functions |