Forum Discussion
"IF" or conditional formatting
I have E46 name formatted to a value of three. I want to get E47 to be the formula of D47 multiplied by the E46 name format of three but only if D47 is a negative number AND D48 is a positive number....
I don't know what do you mean under "name format of three", but the idea of the formula
=IF( (D47<0)*(D48>0), "cslculation here", "no result")