![]() I need the correct formula to subtract one number from another.divide the result by two and then add one of the original numbers. ![]() At the moment I can only get it to subtract a static value like this: I'm returning the first value using a vlookup =VLOOKUP(Homepage!A2,Data!A:D,2,FALSE) And I need to then subtract the value from the cell above it on that sheet (It's B6) from it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |