Conditional display in Excel templates

Question

Summary Conditional display in Excel templates Content Hi All, I have an xls template, where I need to display cell data (Egs Column A) only if another cell (Egs Column B) contains data. Is there a way to use in Excel templates similar to how we used them in RTF? If this is not the right format, how can we display field data conditionally in the template? Thanks!

sumanths · Answer

Thanks Brajesh for the pointers, It helped: Provide xsl:if condition in column B:

(Display Taxable Amount only if a given Tax is applied) Thanks!

Brajesh Shukla-95078 · Answer

Hi , Can you create the XDO_METADATA for if condition and use it on excel. Regards, Brajesh

Brajesh Shukla-95078 · Answer

Hi,

You can use Excel if condition .

In your case "I need to display cell data (Egs Column A) only if another cell (Egs Column B)  contains data"

in this case for cell A you can write like below

=IF(B1="","",A1) --it means If B is blank then A also will be blank and if B is not blank then it will display value of A

Above is easiest way,

Another way is to define the Template tags and use it on you excel

e.g. as below

Regards,

Brajesh