Excel Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am setting up a basic excel spreadsheet and really have got no experience
with excel. I want to do something real basic like if A2=laptop display $10
or if A2=desktop display $20 how do I do this?
 
I think that if the list of options is more than a just a few, a =vlookup()
function would work nicely.

It may seem a little complex to start, but once you use it, you'll find tons of
more reasons to use it.

Debra Dalgleish has some nice instructions at:
http://contextures.com/xlFunctions02.html
 
BadSector said:
I am setting up a basic excel spreadsheet and really have got no experience
with excel. I want to do something real basic like if A2=laptop display $10
or if A2=desktop display $20 how do I do this?
Click to expand...
If you explain what you're trying to do in more detail you will
get more detailed responses.

gls858
 
G'day BadSector,
I am only learning too, but I find it helps when answering.
I would put the formula in B2 as..........

=IF(AND(A5="Laptop Display"),10,IF(AND(A5="Desktop Display"),15,""))

Format the cells to Currency.

If I am incorrect, I am sure I'll be notified :)

HTH



| I am setting up a basic excel spreadsheet and really have got no experience
| with excel. I want to do something real basic like if A2=laptop display $10
| or if A2=desktop display $20 how do I do this?
|
|
 
Explanation:

The formula reads..
If a2="laptop display" give it a 10
If a2="desktop display" give it a 20
the AND's connect the formula query
if any of the queries returns a false reading eg:"Monitor Display"
then leave the cell blank (the two quotation marks at end.. "")

you can substitute the numbers to taste/requirements

HTH

=IF(AND(A2="Laptop Display"),10,IF(AND(A2="Desktop Display"),20,""))
 
Hi!

You don't need AND. It's not doing anything!
=IF(AND(A2="Laptop Display"),10,IF(AND(A2="Desktop Display"),20,""))
Click to expand...

=IF(A2="Laptop Display",10,IF(A2="Desktop Display",20,""))

AND is used to check multiple conditions:

=IF(AND(A2="Laptop Display",B2="Desktop Display"), TRUE,FALSE)

Biff
 
Believe the OP's meaning of "display" is == return/show the value
So the lookup values would probably be just: Laptop, Desktop <g>
 
You are my luminary Biff!
Thanks,
See, one does learn by attempting replies :)


| You don't need AND. It's not doing anything!
| > =IF(AND(A2="Laptop Display"),10,IF(AND(A2="Desktop Display"),20,""))
| =IF(A2="Laptop Display",10,IF(A2="Desktop Display",20,""))
| AND is used to check multiple conditions:
| =IF(AND(A2="Laptop Display",B2="Desktop Display"), TRUE,FALSE)
| Biff
 
Back
Top