IF function with percentage rule

[Tempefamily]

If someone can help me create create the formula for this I would greatly appreciate it.

I need to create a rule for: If G14 is 20% or more than C14 then I want to subtract G14 from C14 on this total be in the cell. If it is less than 20% do nothing.

Thank you

[bonny24tycoon]

Hi Tempefamily,

try this formula anywhere -

Please Login or Register  to view this content.

Thanks,

Bonny Tycoon




**If I was able to help please click the small star icon at the bottom left of my post **

[Cutter]

This is obviously an Excel question but you have posted in the Outlook Help Forum. Oops!

[bonny24tycoon]

Hi Tempefamily,

I understand that your query is resolved. Can you mark this thread as solved. To mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

[arlu1201]

Bonny,

The user will not be able to mark their thread as solved beyond 48 hrs of creating the thread.

Thread moved to the Excel Formulae & Functions subforum.

[bonny24tycoon]

Thanks Arlu