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))
You can use this query written for you.
=IF([Pagetype]="Black & White",([page no]*11),IF([Pagetype]]="Color",[page no]*19))
=IF([Pagetype]="Black & White",([page no]*11),IF([Pagetype]]="Color",[page no]*19))
- Thank you so much Santhosh! There are some other ones I have to create for other lists like shipping but now I understand the formula on how to do them. You help was extremely appreciated! Also thank you to everyone else that helps me with this. Had trouble finding forums online for this formula.
