Create an IFOR formula

Question

I am trying to create a formula to find any fields that are greater than $1,000, if true, then 0, if false, then $5.00. Below are the fields I created and the formula I am trying to use.

=IF(OR(A1>1000,B1>1000,C1>1000,D1>1000,E1>1000,F1>1000,G1>1000), 0,H2)

harun24hr · Answer

Cheryl0615&nbsp;Simply use-=IF(A1:G1&gt;1000,0,5)&nbsp;&nbsp;

cheryl0615 · Answer

Hello Harun,How can I get only one field to populate if any of the fields are not greater than 1000? I only want to see the 5 listed once if any of the fields match the criteria. thanks

hansvogelaar · Answer

Cheryl0615&nbsp;
Try
=IF(OR(A1:G1&gt;1000), 0, 5)

cheryl0615 · Answer

The criteria worked by only populating in column H1, but it gave me a 0 total. I can't copy or cut &amp; paste my example in the response.

cheryl0615 · Answer

Cheryl0615&nbsp;&nbsp;

Forum Discussion

Create an IFOR formula

7 Replies

Resources