Forum Discussion

DaveM790's avatar
DaveM790
Copper Contributor
Feb 25, 2022
Solved

HELP creating a table of some type

I am trying to create a table??? The letter "A" is a number entered by myself between 25-46, 27 in this example then B1= 362.522 - B2 (a percent ,EX 2%) = 355.271...... C1=the same value in D 362.522...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 25, 2022

    DaveM790 

    =VLOOKUP($B$1,$E$3:$F$24,2,FALSE)*(1-B3/100)

    Is this what you are looking for? 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 25, 2022

DaveM790 

=VLOOKUP($B$1,$E$3:$F$24,2,FALSE)*(1-B3/100)

Is this what you are looking for? 

  • DaveM790's avatar
    DaveM790
    Copper Contributor
    Feb 26, 2022
    Never mind, I figured it out. Should be a "," and not a ";". Thank you so much for your help!

    Dave
  • DaveM790's avatar
    DaveM790
    Copper Contributor
    Feb 25, 2022

    OliverScheurich 

    Looks correct but having an issue with the cell calcs. Here are the actual cell numbers, can you translate for a newbie please?

     

     

Resources