abosulte addressing in excell

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

Report •


#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%) requires
IF'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.

MIKE

http://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:

<IMG src="http://i440.photobucket.com/albums/qq121/DerbyDad03/WinTV_Works.jpg"/>


Report •

Related Solutions

#4
March 10, 2010 at 01:12:28
Thanks to all DerbyDad03 and mike


or click here to view the image

i 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
How about this...

=VLOOKUP(A7&" %",$A$1:$B$4,2,0)*B7


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 •

Ask Question