Forum Discussion

Marit Poutamo's avatar
Marit Poutamo
Copper Contributor
Jul 14, 2017

Make a new formula how automaticly change ordinary numbers into manipulated numbers.

Hi!

I have a problem that I cant solve. Somthing is wrong, but I cant figuer it out! I would be very grateful if someone have the time and the knowledge to help me! Thank you for your help!/ Marit Poutamo

 

The formula goes like this; =INDEX(´Values´B4:B43(´Values´ C4,E3:F6,0),4)

Number index

4=4

3=0

2=-1

1=-2

BI & Data Analytics
Need Help
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jul 15, 2017
    Hi Marit

    Can you give a bit more explanation if what you are trying to do and ideally post some screenshots or a sample file.

    It's not clear from your description what you are trying to achieve with the formula?

    Thanks

    Wyn

Resources