Excel Formula Help
 

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 wrote:

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?

--

Dave Peterson

BadSector wrote:
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?


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?
|
|

Oops.
correction

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

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,""))

=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

"Rodney" wrote in message
...
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,""))

Believe the OP's meaning of "display" is == return/show the value
So the lookup values would probably be just: Laptop, Desktop <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

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