Microsoft Microsoft office excel 2007 ac...
March 9, 2010 at 08:20:30
Specs: Windows Vista
 <- see image shown above ->Im trying to calculate the retail price which is original peice* percentage (e.g. c7= 410*125% ). My questions is how can i use absolute cell referencing to calculate the retail price (c7:14)?The WRONG function below is how far i got=(IF(LEN(\$A\$3)-2=LEN(A9), (\$B\$3:\$B\$6),0))*(F9)Please help!

See More: abosulte addressing in excell

#1
March 9, 2010 at 08:51:29
 I'd love to help, but you've confused me.I don't see how a simple multiplication (410*125%) requiresIF's and LEN's and A9's and F9's, etc.I'm not even sure how any of this relates to Absolute References.There has to be a lot that you haven't told us about your layout and inputs and outputs.Could you clarify things a bit?

Report •

#2
March 9, 2010 at 09:07:26
 <- see image shown above ->There is no image above.To post a screen shot or picture you need to post it on a free image site and post the link here.MIKEhttp://www.skeptic.com/

Report •

#3
March 9, 2010 at 09:49:13
 re: To post a screen shot or picture you need to post it on a free image site and post the link here.Sort of...Images can be seen directly in a computing.net post if 3 conditions are true:1 - The correct HTML IMG tag is used.2 - The image is stored elsewhere.3 - The member viewing the post has Images ON selected in their computing.net Settings.I can see this image in my post:The syntax is as follows:``

Report •

Related Solutions

#4
March 10, 2010 at 01:12:28
 Thanks to all DerbyDad03 and mikeor click here to view the imagei want to write a function in cell c7 := if a7 equals a1 then multiply b1 by b7. Then i want to apply this function to other cells that is c8:c14. I was thinking of using Absolute Referencing to make show i restrict comparision to cells a1:a4 only.

Report •

#5
March 10, 2010 at 04:02:01

Report •

#6
March 10, 2010 at 09:19:06
 THANK YOU VERY MUCH DerbyDad03...PROBLEM SOLVED

Report •

#7
March 10, 2010 at 11:12:15
 Glad to have been of assistance.Thanks for the feedback.

Report •