Guys, I need to do something which is probably very simple for you.
I have a spreadsheet I'm making for someone but I suck at math although it's probably very simple.
I have one field where I want to enter a value in % and then I want to multiply that with the total of a bunch of other fields but not sure how to express it.
I tried this =(D47+D44) where D47 is the total of the other fields and D44 is the field formatted as PERCENTAGE but all it adds is .02 to the end of my total (if I entered 2% that is).
Also, what I do now is make a field first where it calculates the TOTAL of 4 fields and THEN add another field for the total times the percentage simply because I don't know how to do this all in one field.
Any help?
Thanks
George
Bookmarks