ok simple question for you guys, is there a simple way to add or take away a % change to all values in a table? or do you have to figure each value up individualy?
i'm betting there is an easy way i am overlooking or just not aware of.
ok simple question for you guys, is there a simple way to add or take away a % change to all values in a table? or do you have to figure each value up individualy?
i'm betting there is an easy way i am overlooking or just not aware of.
open the table and use function window up the top and use multiply function enter your value 1 being the same 0.5 being half of previous value 1.5 1 and a half previous value drag and select all cells you want to change and hit exicute
ahh thanks knew it was something simple, i had played with that feature too just didnt get what i expected, musta been doing it wrong lol no suprise
to add 30% multiply by 1.30 to take away 30% multiply by 0.70 maths isnt my fortey but i think its right LOL
:)Alternatively, you could add 30% by dividing by .7 and reduce by 30% by dividing by 1.3....
Divide ops take more processor time.
Bookmarks