Previous Topic Next Topic

Logical Test Formula

Closed
Dan - Sep 2, 2010 at 11:26 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Sep 3, 2010 at 11:45 AM
Hello,

Does anyone know the reverse or opposite of the following formula:

=IF(N9=0,IF(O9=0,P9*(-1),O9),"") In the formula, N=Wingding2(checkmark), O=Weekly invoiced total, and P has no value. When I enter a checkmark into N9 I want my weekly total to appear in a seperate cell. Currently, entering the checkmark causes the weekly total to disappear? Any help is appreciated.






1 response

Answer 1 / 1
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Sep 3, 2010 at 11:45 AM
=IF(N9<>0,IF(O9=0,P9*(-1),O9),"")

Saying N9 does not equal 0. ie. it has a value, seems to work.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
What is the difference between the number of cores and the number of logical pro
jamalnuman -
jamalnuman -

7 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response