View original (French)

Insert the $ symbol in an Excel formula

mita -  
asco3 Posted messages 133 Status Member -
Hello,

I am having difficulty inserting the $ symbol in a formula in Excel. For example, if the formula I want to enter is: G1+$B$3*((E1/F1)-G1). My question is how to insert the $ symbol in the formula? When I manually enter the formula, the cell does not give me the answer. Thank you.

Configuration: Windows Vista / Internet Explorer 9.0

4 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    I think you want the dollars to have an absolute address
    Click on the cell and in the formula bar select the address to lock and press the F4 function key
    Once locked, the address in both row and column
    2 locks in row
    3 locks in column
    4 unlocks everything
    2