im having trouble writing down a formula like this:
i want the answer in K7
K7=I7-c7-F7
the value in F7 is =I3 wich is an "t"
is there a way that the formula sees the value in f7 = the value of I3?
K7=I7-C7-F7(wich is I3) -F3-C3
thxWerkmap 7.xlsx
im having trouble writing down a formula like this:
i want the answer in K7
K7=I7-c7-F7
the value in F7 is =I3 wich is an "t"
is there a way that the formula sees the value in f7 = the value of I3?
K7=I7-C7-F7(wich is I3) -F3-C3
thxWerkmap 7.xlsx
Last edited by imstuck!; 10-15-2022 at 07:52 AM. Reason: waorkbook
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
posted at same time as AliGW
So ignore
rather than a PDF - can we have a sample spreadsheet as per the details in yellow banner above
in K7 you have the formula
=I7-C7-F7
If F7 is a text value the letter t - then not sure how that happens
=I7-C7-F3-C3
as i say not really following and a spreadsheet with expected results
Last edited by etaf; 10-15-2022 at 07:20 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Attach a workbook instead of a huge image that we cannot manipulate and unnecessarily clutters the post.
You get better help if you add the expected result manualy in your file.
After updating the file let us know so we can take a look at it.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Yep - clear as mud!
Explain the t situation: what is it? Why are you using t? Is it really t in your data, or something else?
Add your expected result to the workbook and explain in more detail the logic behind what you are asking.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks