LinkBack URL
About LinkBacks
I need some help to multiply between two sheets in same workbook.
Sheet 1 cell F2 will have number and on Sheet 2 I want it to be 0.45 x the number in Sheet 1 C2 and I just can't seem to find a forumla that works. Can anyone help?
Thanks in advance!
Forumla for multiplying cells from two sheets
I need some help to multiply between two sheets in same workbook.
Sheet 1 cell F2 will have number and on Sheet 2 I want it to be 0.45 x the number in Sheet 1 C2 and I just can't seem to find a forumla that works. Can anyone help?
Thanks in advance!
=Sheet1!C2*0.45
Click on star (*) below if this helps
Excellent, thank you so much!!Originally Posted by K m
I'm not sure what the number in sheet1!F2 has to do with it.
For the value in sheet2
=0.45 * Sheet1!C2
Is that what you are asking for?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Whatever is in Sheet 1 Column F needs to be multiplied by 0.45 on Sheet 2 Column C
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks