Hello, I have been racking my brain. Any help would be greatly appreciated.
I need a formula to caculate the following:
The plus and minus signs are in a1 to a4 cells and I need a5 to calculate a value based on the combinations of these cells. Please see below for the values needed. Thanks for any help you can be.
++++ =1
+++- =2
++-- =3
+--- =4
---- =5
-+++ =6
--++ =7
---+ =8
-++- =9
--+- =10
-+-- =11
+--+ =12
+-++ =13
+-+- =14
++-+ =15
-+-+ =16
I need a formula to caculate the following:
The plus and minus signs are in a1 to a4 cells and I need a5 to calculate a value based on the combinations of these cells. Please see below for the values needed. Thanks for any help you can be.
++++ =1
+++- =2
++-- =3
+--- =4
---- =5
-+++ =6
--++ =7
---+ =8
-++- =9
--+- =10
-+-- =11
+--+ =12
+-++ =13
+-+- =14
++-+ =15
-+-+ =16