Forum Discussion
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. =...
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
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
- 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.
Could you make a small sample workbook demonstrating the problem (without sensitive data) available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.Isn't that what you asked? "find any fields that are greater than $1,000, if true, then 0, if false, then $5.00"
Several of the values in A1:G1 are greater than $1000, so the formula returns 0.
If you want the reverse of what you asked, i.e. return 5 if any of the values in A1:G1 is greater than 1000:
=IF(OR(A1:G1>1000), 5, 0)- Sorry, yes the reverse is what I'm looking for as the end result. That worked! Thank you.