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.

make correction in search formula containing formula

Thread starter arif
Start date Mar 22, 2016

A

arif

Member

Mar 22, 2016

#1

sir

find this new format file and suggest some ways to correct formula

thanks

B

bosco_yip

Excel Ninja

Mar 22, 2016

#2

Try,

=IF(ISNUMBER(FIND("5%",C11)),C5*D5,C6*D6)

Regards
Bosco

John Jairo V

Well-Known Member

Mar 22, 2016

#3

Hi to all!

Another option:
=IF(COUNTIF(C11,"*5%*"),C5*D5,C6*D6)

Blessings!

You must log in or register to reply here.

Share:

Facebook X Bluesky LinkedIn Reddit Pinterest Tumblr WhatsApp Email Link

Top