Hi,
Just need some guidance with an fx calc i am doing in forms. It is very simple in excel, but when i try and do it in Forms i don't get it to work.
i have 2 Fields where i am Dividing 2 number fields =DIV(Variable1,Variable2) and then i have another field where i have to take the answers from the DIV (variable3) and x 100 which is working as it should. Challenge is, i want to do this in 1 calc =PRODUCT(DIV(Variable1,Variable2),100) which should be correct? However, i am not getting an answer. I have tried using =PRODUCT(DIV(Variable1,Variable2)*100) as well.
Also, i noticed the there is no PMT function. Is there anything else in the functions to accommodate this or should it be done on separate fields.
https://support.office.com/en-us/article/pmt-function-0214da64-9a63-4996-bc20-214433fa6441
Regards,
Gert