Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Perhaps you could explain to us what you are expecting the SUM function to
do for you if you give it only one argument? In what way do you expect =SUM(Sheet2!B1/28) to differ from =Sheet2!B1/28 ? In what way do you expect SUM(1013-Sheet2!B4)*28 to differ from (1013-Sheet2!B4)*28 ? If you don't understand what the SUM function does, you'll find the details in Excel help. -- David Biddulph hoyos wrote: How can I the following formula into a vb code. =SUM(Sheet2!B1/28)+Sheet2!B3 and +SUM(1013-Sheet2!B4)*28 Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Help! creating code for time to decimal calculations | Excel Worksheet Functions | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |