Enter Y If calculation greater than X

**cableghost** · 06-26-2021, 05:24 PM

In the attached workbook, I want to run an IF statement in Cell DATA F2. Below is the formula that doesn't work for me. I've tried just using cells, but that doesn't work either.

If @HIGH-@ENTRY is >= 2, then Y, otherwise blank cell.

Please Login or Register  to view this content.

**Vraag en antwoord** · 06-26-2021, 05:36 PM

2 <> "2" number vs text

PHP Code:


=IF(([@HIGH]-[@ENTRY])>=2;"Y";"")

**cableghost** · 06-26-2021, 05:43 PM

Thank you though this formula gives me that error... There's a problem with this formula.

**Vraag en antwoord** · 06-26-2021, 05:46 PM

Change ; in ,

PHP Code:


=IF(([@HIGH]-[@ENTRY])>=2,"Y","")

**Vraag en antwoord** · 06-26-2021, 06:19 PM

Thanks for the feedback

Enter Y If calculation greater than X

LinkBack

Thread Tools

Rate This Thread

Display

Enter Y If calculation greater than X

Re: Enter Y If calculation greater than X

Re: Enter Y If calculation greater than X

Re: Enter Y If calculation greater than X

Re: Enter Y If calculation greater than X

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to enter date associated with last number greater than zero or last zero in row

[SOLVED] How do I enter a IF Function Greater Than Or Equal To in a cell?

[SOLVED] Calculation formula greater than less than

[SOLVED] Calculation if greater than 8

If greater than '0' enter value from a table on a different worksheet (tab)

[SOLVED] IF a value is greater than X, do this calculation - but how?

How do you enter greater than?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions