If and + if or

[redJohn89]

Hi,

In my attached data set, I am trying to find a formula which will give me the desired output in Col D. The formula should first check if Type (Col A) = "Home" and only if it is true then it should check Description (Col C). Under Col C it should check if the cell contains full Upper Case text then it should return "Type A" under Col D. If Col C contains lower case or proper case or anything else then it should return "Type B" in Col D. If Col C contains a blank cell then it should return "No Notes". Please note that the Type (Col A) should be equal to "Home", only then proceed with the above checks. If the value of a cell under Col A is not equal to "Home", then it should return a value of "Not Applicable" under Col D. Hope this helps.

[AliGW]

You cannot use formatting as a formula criterion. Formulae cannot 'see' formatting. Unless you think of a different approach, it will have to be VBA.

Your thread title is really quite poor, and tells us nothing about the fact that you are trying to use text formatting in the formula - please be more detailed in your thread titles in future.

[redJohn89]

Hi,

I apologize for the title, I will be more accurate moving forward. This is the formula I have to check the case logic: =IF(ISBLANK(C2),"No Notes",IF(EXACT(C2,UPPER(C2)),"Type A",IF(EXACT(C2,LOWER(C2)),"Type B","Type B"))). I just want to add another AND condition which first checks if Type = "Home" before applying the above formula. Please let me know if this is possible.

[TMS]

Try:

Please Login or Register  to view this content.

[redJohn89]

Hi TMS,

Your formula worked. Thanks a ton !

[TMS]

You're welcome. Thanks for the rep.