Author

Topic: Need help (Read 282 times)

full member
Activity: 154
Merit: 100
January 15, 2014, 10:28:39 AM
#1
I need a little help with Microsoft Excel. I have this function =IF(D9>C2;A2;IF(D9>C3;A3;A4)) and I want that Only D9 coordinate would change and c2 a2 and other ones would ramain the same when I try to extend them. So how do I lock coordinates in fuctions ? I tried googling it but found nothing :/ Found the awnser i was looking for. Thanks for the help. $
Jump to: