Forum Discussion

Greg Bonaparte's avatar
Greg Bonaparte
Iron Contributor
Jul 30, 2020

MULTIPLY NEGATIVE NUMBERS

The following macro needs to be false if BD an BE are negative values. I'm not clear how to.  The formula used in cell BF... is =(BD...)*(BE...) Sub BFSORT() Application.Calculation = xlManual ...
excel
Formulas and Functions
Macros and VBA
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jul 30, 2020
=PRODUCT(ABS(BD1:BE1))

Without VBA

Nikolino
I know I don't know anything (Socrates)
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 30, 2020
    sry this is the formulas
    =PRODUKT(ABS(BD1*BE1))

Resources