Help po sa excel

[Freakster002]

paano po gawan ng formula yan sa excel mga lods. salamat po sa mga magaling gumawa

 

[yahj2]

medyo magulo ata .. pa help tayo sa mga expert .. up ko

 

[Loooopit]

up naten yan lods

 

[Man with No Name]

Freakster002

You can use VLOOKUP.

Download/see attached Excel sheet for your reference.

Hope this helps.

 

[yahj2]

Freakster002

You can use VLOOKUP.

Download/see attached Excel sheet for your reference.

Hope this helps.

galing naman nito boss, walang lookup value pero may result

 

[Man with No Name]

galing naman nito boss, walang lookup value pero may result

• Column E contains the given number you want to look up
• A1:C5 contains the number range and the value it will return based on the given number
• The number 3 (in the formula) means that the value it will return locates in the third column of range A1:C5

You can test if the formula works by changing the number/value in Column E.

 

[Freakster002]

thank you

 

[Man with No Name]

thank you

You're welcome.

 

[itsmeurbebegirljasmine]

You can use the following Excel formula in cell B1 to achieve the specified conditions:
excelCopy code
=IF(A1<=25000, 100, IF(A1<=50000, 200, IF(A1<=100000, 300, 400)))
Here's how the formula works:

• If the value in cell A1 is less than or equal to 25,000, it returns 100.
• If the value in cell A1 is greater than 25,000 but less than or equal to 50,000, it returns 200.
• If the value in cell A1 is greater than 50,000 but less than or equal to 100,000, it returns 300.
• If the value in cell A1 is greater than 100,000, it returns 400.

You can drag this formula down to apply it to the entire column B.