Comments on: How To Subtract in Google Sheets: The Ultimate Guide

By: jmarkus

jmarkus — Mon, 06 May 2024 16:14:10 +0000

In reply to Steven Atkinson. I think it's right: value1 represents the minuend (the number from which another number is to be subtracted). value2 represents the subtrahend (the number to be subtracted from the minuend).

By: Christopher Daniel

Christopher Daniel — Wed, 14 Dec 2022 02:56:15 +0000

In reply to dave. The result will show as a negative integer. For example, if you perform $100 - $200 the result would be -$100.

By: Stephen

Stephen — Sat, 08 Oct 2022 08:28:29 +0000

Unfortunately I don’t see the formula to subtract a percentage from a cell?
any help would be great thank you in advance.
steve.

By: dave

dave — Fri, 22 Jul 2022 20:19:47 +0000

This is helpful – BUT – what happens in the case where you have, let’s say one cell B1 at a fixed dollar amount and the second cell B2 with a varying number. My example refers to the closing price of a Stock the previous day at say $110.00. And B2 is a current and continually changing number until the end of the day. But you want to find out your gain or loss during the day between 9:30 am and 4 pm. If you have the function set up for Minus to subtract B2 from B1 and B2 is a larger number, how will that work ?

By: Belle

Belle — Mon, 21 Feb 2022 07:10:01 +0000

Very useful thankyou google

By: Anais

Anais — Tue, 23 Feb 2021 04:54:26 +0000

I found this really useful. Thank you. 🙂

By: Steven Atkinson

Steven Atkinson — Wed, 17 Feb 2021 10:10:43 +0000

Hi
Under the section titled – Method Two, it looks like you have put Here:

value1 is the subtrahend.
value2 is the minuend.

I think you may have this the wrong way round