using IF statement < > AND? OR?

**jaydee-187** · 03-30-2017, 12:07 PM

Think I've managed to solve it:
=IF(AND(C37>=S36, C37<S38), C37*R36,IF(AND(C37>=S38, C37<S40), C37*R38, IF(C37>S40, C37*R40)))

Also, if the amount (c37) is less than 100, how can the field return 0

**JohnTopley** · 03-30-2017, 12:17 PM

Try

=IF(A1<100,0,IF(A1<290,A1*5%,IF(A1<500,A1*10%,A1*15%)))

using IF statement < > AND? OR?

LinkBack

Thread Tools

Rate This Thread

Display

using IF statement < > AND? OR?

Re: using IF statement < > AND? OR?

Thread Information

Users Browsing this Thread

Similar Threads

nested IF statement or AND? trying to write an IF statement with multiple conditions

[SOLVED] If statement to select data - nested statement - assistance

compile error expected line number statement end statement

VBA Compile Error : line number or label or statement or end of statement

[SOLVED] Convert If statement with cell row reference calculations to vlookup statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions