Forum Discussion
Help with this "IFS" statement in office 365
Detlef, I have attached the complete file as it stands now.
There are a numer of complete as well as incomplete components as you will see.
I was starting a slow process of working out each of the formulas.
It has nothing to do with milk or cheese, they were just easy names that did not need any explanation.
The particular formula I was discussing is on the tab called Pay Calculator where the two conditions are in Cell B3 and E8 with formula resulting in cell F8, H8, J8, L8.
So as the name or value changes in B3 or E8 then so will the values in F8, H8, J8, L8 change.
Thanking you for offering to have a closer look at the situation.
Luigi
http://www.OodlesofUtils.com
A Game of Choices and Trade Offs
Oh my. You are using the wrong quotes.
You are using character 147 (“) instead of character 34 (").
Well that is interesting!
Where do I find character 34?
To me 147 looks the same as 34
Is it a specific font type?
On my keyboard it's on SHIFT-2.
And to be more precise, you are already using character 34 in the last part of the formula (around No match).
How would I know if i am using 34
The only key on the keyboard that has any similarity to this, is " the key next to the left of the return key.
Also if I am using this key stroke what defines it?
It is getting curious and curiouser!