Need a little help with a simple operation.

[Neomorpheus]

Hello everyone,

I am trying to subtract from two cells that ends in MB, but cant find a way to do this.

Example:

Cell 1 value is 2000 MB, Cell 2 value is 1500 MB.

All i want to do is subtract from Cell 1 using Cell 2 value and return a result also using MB.

No matter what i have tried, i keep getting a #Value error.

Please advice and sorry, but I am a complete noob with Excel.

 

[Neomorpheus]

You could also substitute the MB out of it:

=ROUND((SUBSTITUTE(A1,"MB","")-SUBSTITUTE(B1,"MB",""))/1024,2)&" GB"

Thanks!

 

[jtakw]

Actually, that worked perfectly.

Again, thank you very much!!!!

You're very welcome, welcome to the forum.