Previous Topic Next Topic

If Formula Help

Closed
JessieJane - Aug 5, 2010 at 03:29 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 5, 2010 at 05:41 PM
Hello,

I am hoping someone is able to help me figure this out. I'm feeling beaten by a spreadsheet right now.

Okay so I have created a drop down list in Column A. What I want to do in Column B is when the Name in Column A matches the name is Worksheet 1 Column C then Column B equals the Value of Worksheet 1 Column F. How Do I do this

I was trying to enter this and I continue to get errors I don't know how far off I am.

=IF(B4=Prices!A6,Prices!F6,0)OR IF(B4=Prices!A7,Prices!F7,0)(OR IF(B4=Prices!A8,Prices!F8,0))

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 5, 2010 at 05:41 PM
No idea what you asked or were doing Looking at your statement, looks like if statement is wrong

=IF(OR( cond1, cond2, cond3...), <show this if either cond was true>, <show this if neither condition was true)
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response