If condition is true then either add or multiply or else keep zero

**MYEM1983** · 04-29-2017, 05:23 PM

Dear All,

Your kind assistance will be highly appreciated.

If B28>=1 then in true situation either it Multiply B3 and C28 and where B3 is empty then take C28*1% and if B28 is not equal or greater than 1 then keep ZERO or empty.

How should I write formula? Appreciate your assistance .

**gmr4evr1** · 04-29-2017, 05:37 PM

Maybe this....

Formula:

Please Login or Register  to view this content.

**MYEM1983** · 04-30-2017, 02:50 PM

Dear Tom,

Thank you for your help

I just made small change in this formula and it working fine!!

Thank you so much!!

**gmr4evr1** · 04-30-2017, 03:20 PM

No problem. I'm glad you were able to get it working to your liking.

**MYEM1983** · 04-30-2017, 03:42 PM

Thank you!!

If condition is true then either add or multiply or else keep zero

LinkBack

Thread Tools

Rate This Thread

Display

If condition is true then either add or multiply or else keep zero

Re: If condition is true then either add or multiply or else keep zero

Re: If condition is true then either add or multiply or else keep zero

Re: If condition is true then either add or multiply or else keep zero

Re: If condition is true then either add or multiply or else keep zero

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] SUM a column but multiply if condition is met.

[SOLVED] Multiply numbers with multiple condition

Help popup window if condition is TRUE in change event if conditon is true

[SOLVED] subtract days between due date and todays date, if condition 1 and condition 2 are true

open a comment to cell range upon true condition then removing comment on false condition

Match a condition and multiply columns

Multiply with a condition

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions