Writing A Formula

**mightyeskimo** · 08-25-2011, 02:45 PM

Hi. I am new to excel and need someone to help me translate the following into a formula. Please excuse me as I'm still learning. Thanks.

If the value of the number in 'Sheet Name'$B$15 is greater than the value of the number is "Sheet Name'$B$16 by a value that is greater than equal to half of the value of the number in 'Sheet Name'$E$16 then display the text Very Strong.

**Domski** · 08-25-2011, 02:57 PM

Hi,

Try:

=IF('Sheet Name'!B15-'Sheet Name'!B16>'Sheet Name'!E16/2,"Very Strong","")

Dom

**mightyeskimo** · 08-25-2011, 03:07 PM

Thanks Dom! That works great! How would I add a second argument to that formula? It's in the same structure as the first but uses a different calculation and results in the text Strong if true.

**Domski** · 08-25-2011, 03:13 PM

Something like this:

=IF('Sheet Name'!B16-'Sheet Name'!B15>'Sheet Name'!E16/2,"Very Strong",IF('Sheet Name'!B16-'Sheet Name'!B15>'Sheet Name'!E16/3,"Strong","Not so strong"))

Dom