Excel Formula Function to Subtract randomly

Question

I want to subtract on a fixed amount but randomly using Excel or possibly another tool, but I'm not very experienced with it. Similar to n1 + n2 +1 = 300 However, I don't want to divide since I want n1, n2, and n3 to be separate numbers.

Examples 150 + 75 + 75 = 300

or

100 + 100 + 100 = 300

or

50 + 100 + 150 = 300

A function to subtract a fixed amount but random subtraction I'm still quite confused on how to do this on excel, sorry for my bad English and explanation Please help

Answer 1

The first number we use:

=RANDBETWEEN(1,A1)

Then the second:

=RANDBETWEEN(1,A1-B1)

Then the third is just the remainder:

=A1-B1-C1