Forum Discussion
Solved
SharePoint Calculated List Column
Under a standard custom list, can I use the calculated field to assign values to a choice field that has words not numbers? We want to determine cost for printing in black and white vs color. I have a...
- You can use this query written for you.
=IF([Pagetype]="Black & White",([page no]*11),IF([Pagetype]]="Color",[page no]*19))
Maybe I can explain it a little better. I have a list already created. I have a field with a dropdown for ink color that has "Black & White" and "Color" as an option. I also have a single field called paper quantity. Black & White costs 11 cents a side and color costs 19 cents a side. I was hoping I could have Black & White represent .11 and Color represent .19 and then times it by the quantity category and have it output in the form as a total estimated cost. Does that sound like it would work? Let me know what you think and thanks for responding!
Hi Brian
Assuming that by dropdown field, you mean that you are using a Choice column and that it has the two options "Black & White", and "Color".
If that is so, you calculated column, should be able to have a formular like:
=[Quantity] * IF([Ink color] EQ "Black & White", 0.11, 0.19)
Above is not the real code :) just an example
Enjoy, John
Assuming that by dropdown field, you mean that you are using a Choice column and that it has the two options "Black & White", and "Color".
If that is so, you calculated column, should be able to have a formular like:
=[Quantity] * IF([Ink color] EQ "Black & White", 0.11, 0.19)
Above is not the real code :) just an example
Enjoy, John