[cnebb1981]

Hi, I'm curious if there is a way to make a formula in Excel that will produce a certain word in a cell, like "Yes" or "No" if a value in another cell is a certain number. For example if H7 = 0 then I7 = "No", but if its any other number then it will = "Yes". Thanks for any help.

[olliea95]

Yeah sure. The easiest way to do this is click on the cell you want the formula to be in (I7 I think you said) and click the 'fx' button next to the formula bar. You can then find the 'IF' option and click ok, this will then give you a window to enter in the information easily. The other way is to type the formula yourself, and it follows the syntax "=IF(comparison, ("value if true"), ("value if false")), so in your case it will be similar to "=IF(H7 = 0, ("Yes"), ("No")). (without the first and last quotes)

If typing the formula yourself doesn't work, it must be my fault, so try the 'fx' button if it doesn't. Also I'm sorry if this isn't very precise as I only have Excel 2003 and you may have another version.

-Ollie

[cnebb1981]

Thanks it worked, I sure do appreciate it.

[olliea95]

You're welcome, got lucky as I was trying to recall from memory from about 6 months ago