User Profile
MartynaCzerwinska123
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Word formulas / macros
Hello everyone I'm looking for some help with Word formulas and/or macros. I've created the following table: A - under column A I created a drop down list, the user can select a number from 1 to 5 B - the same as A C - under column C I created a formula that multiplies numbers from column A and B (example: if A=3 and B=5 then C shows 15) Question 1: is it possible for column C to update automatically or do I need to "update file" every time I amend the number under column A or B? Now, what I'm trying to do is for column C to change colour depending on the multiplication result (1-5 green, 6-12 yellow, 15-25 red). I don't think it is possible to do it via formulas? I believe Word enables to use only 1 formula at a time. I came across something called Macros in Word. Does anyone know how to use them? Is it possible to achieve what I'm trying to achieve? I know it can be easily done in excel, but I really need it in Word. Any help or guidance would be greatly appreciated. Kind regards Martyna1KViews0likes0Comments- 853Views0likes0Comments
Excel Formulas
Hello, I'm looking for some help with excel formulas. In column D2 I've got a drop down list, options: Yes, Partial, No, N/A. If I select Yes in D2, I want I2 to show 2 If I select Partial in D2, I want I2 to show 1 If I select No in D2, I want I2 to show 0 If I select N/A in D2, I want I2 to show N/A. Is this possible? So far, I managed to get 3 options correctly by using: =IF(D2="Yes","2",IF(D2="Partial","1","0")) Any help would be much appreciated. Kind regards Martyna908Views0likes2Comments
Recent Blog Articles
No content to show