I need some help with a formula. I want to multiply the values of the 2 fields, let's say fields A1 and A2, but there are couple of condition. If the total of the multiplied values exceeds certain value, let's say 500, then the result must be 500. Also, if the fields A1 and A2 are empty with no values, then this field should also be blank.
Thanks in advance,