Which is the correct syntax to use in this example formula?

[Event2020]

Hi I am still learning Excel and I am very grateful to the good folk on here who generously give their time to answer all of our questions - Thank you. I am writing a simple If formula that looks at cell B1 and if B1 contain the number 1 the formula does one thing but if it contains a different number it does something else. If it contains no number then it does nothing. My question is which is the correct syntax to use in terms of wring good formulas?

=IF(Add_CD_Information!$B$4>1,"Do This","Do That")

or

=IF(Add_CD_Information!$B$4=1,"Do This","Do That")

 

[RoryA]

Neither of those take into account the option of doing nothing if B4 doesn't contain a number. I'd suggest a structure something like:

=IF(ISNUMBER(Add_CD_Information!$B$4),IF(Add_CD_Information!$B$4=1,"Do This","Do That"),"")

where "" is the "do nothing" option.

 

[Fluff]

Those formulae do totally different things.

In the second formula you will get "Do This" ONLY if B4 contains 1
Whereas with the first formula you will get "Do This" if B4 has any number GREATER than 1, OR contains text.

 

[Event2020]

Neither of those take into account the option of doing nothing if B4 doesn't contain a number. I'd suggest a structure something like:

=IF(ISNUMBER(Add_CD_Information!$B$4),IF(Add_CD_Information!$B$4=1,"Do This","Do That"),"")

where "" is the "do nothing" option.

Hi Rory

Yes you are correct, that was an omission on my part :P

 

[Event2020]

Those formulae do totally different things.

In the second formula you will get "Do This" ONLY if B4 contains 1
Whereas with the first formula you will get "Do This" if B4 has any number GREATER than 1, OR contains text.

Hi Fluff

Many thanks

 

[Event2020]

This is what I love about this Forum

I learnt two very useful things with one question!

Thanks guys

 

[Fluff]

Glad we could help & thanks for the feedback