Multiples of 4 in an IF statement

  • Thread starter Thread starter Barry Clark
  • Start date Start date
B

Barry Clark

Hello all.

I have an IF statement in one of my cells.


Code
-------------------
=IF(logical_test,value_if_true,value_if_false
-------------------


In the logical_test portion, would like to have the cell evaluated fo
multiples of 4.

Code
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical IF statements 3
My Duplicate formula is not functioning as it should 3
Using a range as value_if_true in IF function 14
#NAME? error in nested if & VB 1
Why do functions not allow commas to seperate arguments 5
Logical Test 5
Nested IF Statements - Worksheet Function 2
any limit? 2

Back
Top