Question on IF's

K

Kim

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
 
B

Bearacade

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

RagDyeR

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!
=====================================================

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
 
S

Spreadsheet

=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.
 
B

Bernard Liengme

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
 
Top