show error if more than 1 per 1000 points is taken

Question

show error if more than 1 per 1000 points is taken

I need to make a formula than shows an error if more than 1 item per 1000 points is taken. I've tried a few things and can't seem to get it to work. ChatGPT gave me this formula that doesn't show the error.

IF(  MOD(Army Totals::Number Taken $'Points ', 1000) = 0,  IF(  Number Taken '0-1 Mechanized Rifle Company' ≤ Army Totals::Number Taken $'Points ',  "OK",  "Error: More than 1 taken per 1000 points"  ),  "Error: Invalid input" 

Any help with this will be greatly appreciated, Frank

iMac 27″, macOS 12.6

Posted on May 7, 2024 12:58 PM

Reply

Answer 1

Badunit

Level 7

26,242 points

May 7, 2024 7:26 PM in response to franks4business

I truly hate ChatGPT.

I don't know what all those cell references mean or if they are correct so I'm going to use regular cell references. If you want to know the number of points taken per thousand points, you need to know the number of points taken and the total number of points. I don't know what is what in your formula.

Cell A1 in my formula has the number of points taken

Cell A2 in my formula has the total number of points

IFS(A2=0,"no points", A1÷A2>1÷1000, "error", TRUE, "no error")

or

IF(A2=0,"no points", IF(A1÷A2>1÷1000, "error","no error"))

Reply

Answer 2

May 8, 2024 1:09 PM in response to Badunit

Thanks. That worked perfectly. I used the 2nd one. I knew what Chat gave me was way too convoluted, but what I got from the Bing AI site was totally crazy.

Thanks again, Frank

Reply