Thread: Using if statement many times!
View Single Post
 
Old 01-18-2012, 02:22 PM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question Using if statement many times!
Using if statement many times!
I’ve two Cells, A1 and B1. I wanted value of B1 to take a value based on the value of A1 in accordance with the table below:
Item
Kg/m2
House
250
Offices
300
Garage
600
Holes
600
Stores
1,000
Commercial
500
For example, if the A1 takes the “Stores” value then B1 takes the “1000”. To accomplish this, I constructed the If statement below and worked very well:
=IF(O2=B3,C3,IF(O2=B4,C4,IF(O2=B5,C5, IF(O2=B6, C6, IF(O2=B7, C7, IF(O2=B8, C8))))))
My point is:
What if we have long table that may contain 100 rows?
Is the “If Statement” practical to perform this kind of work?
Is there other command to help this issue?
Thank you in advance,
Regards
Jamal
Reply With Quote