Can excel field show a specific value if another field has specific content? ?

Question

ex. If C2=Basic then E2 shows $30000?

Answer 1

Hi Needy,

The formula you had tried is absolutely correct except a small correction. Since you are gonna use a text parameter in range B2 (ex: Level1, Level2 etc) you should code the parameter in if condition as string.

=IF(B2="Level1", 30000,"") (i.e. Level1 in between double quotes)

This will work!!!

Cheers!

Guru

Answer 2

=IF(B2="Level1", 30000, "")

Quotes surrounding a text string should be "double" quotes, not 'single' quotes.  Creating a list is a good idea, and the formula should work either way.

Answer 3

in E2 just enter

=IF(C2="Basic", 30000, "")

this will show 30000 in E2 if C2 is "Basic", othewise it'll show a blank