Are you sure about this? Shouldn't it be:
4 pages, 4-up = 1 master page;
5 pages, 4-up = 2 master pages.
Its actually a page count for printing.
2 Broadsheet = 2 Broadsheet
4 Tabloid = 2 Broadsheet
8 Book = 2 Broadsheet
Pages are entered in a field marked pages, then select a drop down for Broadsheet, Tabloid or Book and I want to auto calculate the number of broadsheet pages used. So the user will enter the pages for the job and then select the type. FMP calculation in a field called Broadsheet Pages will calculate the correct number of Broadsheet pages without the user having to figure it out.
Hope this makes sense, just trying to make it so the conversion is done automatically to avoid any user math errors. I can just have them enter both numbers without any calculations.
It doesn't make sense to me, but I am not a printer. Anyway, try:
Type = "Broadsheet" ; Pages ;
Type = "Tabloid" ; Pages * 2 ;
Type = "Book" ; Pages * 4
Perfect, Thank you very much!