Simple IF formula

[brooksc29]

I have inserted "check" boxes in CR2 and CR3.

I'd like to write a formula in DN6 that says:

If CR2 is checked, enter the text AL AVG
If CR3 is checked, enter the text NL AVG


thanks for your help!

 

[GK039]

Hi there

Rightcllick the check boxes - Go to format control and in the cell link dialog box choose a cell lets say CR1. Type TRUE in CR1

Now use the formula
IF(CR1,"AL AVG","")
Do the same for the second check box

George

I have inserted "check" boxes in CR2 and CR3.

I'd like to write a formula in DN6 that says:

If CR2 is checked, enter the text AL AVG
If CR3 is checked, enter the text NL AVG


thanks for your help!

 

[jc.021286]

So, Just to be sure,
Your Check boxes, right click them and ensure that you have them linked to the cell underneath of them.

This will make it that If the check box is checked, that Cell will be changed to "True" if unchecked "False"
You can change the Font colour to White to hide the text from displaying.

=If(CR2="True","AL AVG",IF(CR3="True","NL AVG",""))

An Option box instead of a check box might be better.
What if Neither is is Selected, I'll have "" which is nothing, it'll appear blank.

However, If both are checked, then CR2 will be triggered as it is the first one that is looked at.

let me know if this points you in the right direction,
jc

 

[brooksc29]

thanks George,

I applied the cell link to both CR2 and CR3 (where the check boxes are) and then in DN6, used this formula:

=IF($CR$2,"AL AVG","NL AVG")

it's not exactly what I am trying to say, but as both check boxes won't be checked at the same time, it works fine.

thanks for your help!

if you have another moment, would you mind looking at this thread?

http://www.mrexcel.com/forum/showthread.php?t=532066