• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Super Logical formula

achu

achu

Member
Dear sir, i need help... i have a documents try to build logical formula but not able to do, my logic is if i received payment against (flat 100000, and service tax 3000. vat 2000) actually i want to get result Flat + Service tax = Vat if cell has number than result get against Heading so i need to filter same as attached files please help this kind of formula.. Thank you,
 

Attachments

Hi,

I think you should try converting your data in Table, rather than go with formula solution.

By using table, you will be able to filter your data with just mouse clicks and you will see the result in few seconds.

First, filter with Project, then Flat No.
also add a total row using Table options.

See sheet 2 example in attached.

Regards,
 

Attachments

Sir, if i fileter project and flat no only showing that particular fields and last cell showing used table header example (Flat + service tax + Vat)

not showing Amount
 
Adding to what Khalid did.

You can add column at end of table and combine IF & ISBLANK to show text string.

=IF(ISBLANK([@Flat])=FALSE,"Flat","")&IF(ISBLANK([@[Service Tax]])=FALSE,"+Service Tax","")&IF(ISBLANK([@Vat])=FALSE,"+Vat","")

If you don't want to show actual columns for each, then you can do advanced filter operation to copy table to another sheet excluding those columns. Or simply hide it.

See sheet 3 for example of advanced query result.
 

Attachments

Thank You :)

Mr Khalid huge thank you for this help

Mr Chihir0 also hugeo thank you for this help
 
You must log in or register to reply here.
Back
Top