I know very basic excel. I'm trying to write a formula working with IF.

My question is if A2 is equal to H than I want it to reflect 1/2%, same
formula, if A2 is equal to I than I want it to reflect 1%.

I also want to ask Yes, No questions and it give me back a %.

Can someone pleeeeaaasssseee help me out with this.
Thank you very, very much!
Kim

To answer your first part, try the following formula:

=IF(A2=H2, A2*0.005, IF(A2=I2, A2*0.01, "A2 doesn't not equal H2 or
I2"))

To do the second part, you must use VBA.. is that what you want?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=555635

Basic IF formula, where if there is *no* match, the cell will look empty:

=If(A2="H",0.5%,If(A2="I",1.0%,""))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Kim" wrote in message
...
I know very basic excel. I'm trying to write a formula working with IF.

My question is if A2 is equal to H than I want it to reflect 1/2%, same
formula, if A2 is equal to I than I want it to reflect 1%.

I also want to ask Yes, No questions and it give me back a %.

Can someone pleeeeaaasssseee help me out with this.
Thank you very, very much!
Kim

=IF(A2="H",0.005,IF(A2="I",0.01,))

this should work for the first part of your question. To modify it for
the second part of your question, simply substitute "Yes" and "No" for
"H" and "I" as well as the numbers that are returned.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=555635

If A2 = "H" then you want another cell to display 1/2%, if A2 is "I" the
other cell is to display 1%, otherwise nothing is to be displayed?
=IF(A2="H",0.005,IF(A2="I",0.01,""))
You will need to format the cell to display percentage - use the % tool. You
will get 0.5% not 1/2 %
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kim" wrote in message
...
I know very basic excel. I'm trying to write a formula working with IF.

My question is if A2 is equal to H than I want it to reflect 1/2%, same
formula, if A2 is equal to I than I want it to reflect 1%.

I also want to ask Yes, No questions and it give me back a %.

Can someone pleeeeaaasssseee help me out with this.
Thank you very, very much!
Kim