How to write =IF((E2>75%)+E2*300) correctly

**TPS** · 09-10-2018, 10:38 AM

I'm sure this is a very easy formula. But I've not used this before.

Cell E2 is expressed as a percentage (eg 82%)
Cell K2 has the formula where the correct result is returned.

If the value returned in E2 is equal to 75% or greater, then multiple 300 by the value in E2.
If Cell E2 is less than 75%, then zero.

If as an example, E2 = 82%, K2 = 82% of 300, ie 246

**modytrane** · 09-10-2018, 10:43 AM

=if(E2>=.75,E2*300,0)

**TPS** · 09-10-2018, 10:52 AM

Thx Modytrane, I knew it would be an easy fix.

How to write =IF((E2>75%)+E2*300) correctly

LinkBack

Thread Tools

Rate This Thread

Display

How to write =IF((E2>75%)+E2*300) correctly

Re: How to write =IF((E2>75%)+E2*300) correctly

Re: How to write =IF((E2>75%)+E2*300) correctly

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Why does code called from a macro button to write data to an excel table work correctly, b

[SOLVED] how to write this if statement correctly

[SOLVED] OFFSET Trouble - Amend function on Userform does not write data correctly

[SOLVED] How to correctly write "Value of cell E16" while having the quotations around it.

How to write this loop macro correctly?

[SOLVED] This is not working because I didn't write it correctly

[SOLVED] How to correctly write a cross-sheet "IF" formula in Excel

Bookmarks

Bookmarks

Posting Permissions