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

Dec 28, 2022 in Others 340 views

## 1 answer to this question.

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
```

• 63,420 points

## Excel formula to check date within this week and last week

Assuming the first date in A2 try this formula ...READ MORE

## Way to overcome Excel Vlookup function limit of 256 characters

If you are using VLOOKUP like this: =VLOOKUP(A2,D2:Z10,3,FALSE) i.e. ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE