#1
|
|||
|
|||
macro
I have a similar file, I'm looking for code that will make summary data at the touch of a button as shown in the example in the file. i have Particular problem in transfer the first row of data |
#2
|
||||
|
||||
hi li roy,
It's not entirely clear what you want to do. That said, I think the following is a better version of the forumula you have in A9: =(($B$2-$C$2)*(1-$D$2)*2+$C$2*(1+(A2>1)))*(A2>0)+(($B$2-$C$2)*0.5+$C$2)*MAX((A2-2),0) This formula allows for A2 to have 0 and numbers greater than 4 - you can even input increments of, say, 0.5 for infants, if you want.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I assign a macro to a button when the macro is in my personal workbook? | foolios | Excel Programming | 2 | 07-27-2011 02:41 PM |