Hi Guys,
I can't work out how to write if statement if I have three sheets with the same Cell name "Test", but I want to pull calculation from Sheet 1&2 to Sheet3, if there is a match on all three sheets e.g:
- Sheet1 in column C = "Test", column E = "$100"
- Sheet2 in column C = "Test", column E = "100%"
- Sheet3 in column B = "Test", column F, I need calculation Sheet1 "$100" x Sheet2 "100%" = "$300"
Can someone help me?
Thanks
Kitsa
How do you get to $300 ? ($100 * 100% = $100)- Sheet3 in column B = "Test", column F, I need calculation Sheet1 "$100" x Sheet2 "100%" = "$300"
You are correct. My bad. I just need to know how to write this statement for it to work.
Edit: Will not work as it will only deal with 2 Sheets, and NOT the 3rd.
Try this
I didn't use TEST but the actually ID as you didn't change it in the sheet
Please Login or Register to view this content.
If one of them is NOT the same as ID it will default to 0
Last edited by iammike; 11-23-2022 at 03:53 AM.
New and improved(This for F3 in Client Invoice)
Please Login or Register to view this content.
Hi Iammike,
This work for individual line if has the name "EQ15111", each line will be different so it won't work on all line when I copy cell.
Last try before I let someone more experienced take over
Please Login or Register to view this content.
Sorry, no good.
Thanks heaps for trying.
If I understand correctly then I feel that you are looking for something like the following to populate cell F3:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks