Forum Discussion

Copper Contributor

Jul 07, 2024

Create an IFOR formula

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. =...

excel

Harun24HR

Bronze Contributor

Jul 07, 2024

Cheryl0615 Simply use-

=IF(A1:G1>1000,0,5)

Cheryl0615
Copper Contributor
Jul 08, 2024
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
  MVP
  Jul 08, 2024
  Cheryl0615
  
  Try
  
  =IF(OR(A1:G1>1000), 0, 5)
  - Cheryl0615
    Copper Contributor
    Jul 08, 2024
    The criteria worked by only populating in column H1, but it gave me a 0 total. I can't copy or cut & paste my example in the response.