In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term. (this is difficult to put in words)

example:

So, I have different values, like 100M, 50M, 30M, 40M, etc.

Now, can I keep the "M" fixed so that I only need to input the numerical value? Like I just type "100" but it shows "100M"?

Is it also possible to have a formula that ignores the "M"?

Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?

Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?

`IF(A10="100M",...)`

or`VLOOKUP("100M",A1:A50...)`

. If the M is just formatting decoration, the actual content will just be a number, so you can do arithmetic with it and format the result the same way. (cont'd)