thank u so much for ur responses... here's an example of what i'm trying to do:
if field1 is equal to 'Y' and field2 is equal to 'cashback' then the calculated value for field3, 4, 5, 6, 7 will be (fieldx / fieldy) * 100
if field1 is not equal to 'Y' and field2 is 'whatever' then the calculated value will be something else for the rest of the ...