=IF(G27>=2%,"X",IF(G27<=1.99%,"●"))
I works if the number is positive but I need it to also work if it goes negative.
Something like: =IF(G27>=±2%,"X",IF(G27<=±1.99%,"●"))
Range of -2% - 2% & -1.99% - 1.99%
"X" = Fail
"●" = Pass
Thanks For The Help
=IF(G27>=2%,"X",IF(G27<=1.99%,"●"))
I works if the number is positive but I need it to also work if it goes negative.
Something like: =IF(G27>=±2%,"X",IF(G27<=±1.99%,"●"))
Range of -2% - 2% & -1.99% - 1.99%
"X" = Fail
"●" = Pass
Thanks For The Help
Hi,
Perhaps
Formula:=IF(ABS(G27)>=2%,"X","●")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Maybe
=IF(ABS(G27)>=2%,"X",IF(ABS(G27)<=1.99%,"●"))
As there are no other possibilities (I assume, unless you don't want to include something like 1.999%) then maybe
=IF(ABS(G27)>= 2%, "X", "●")
or
=IF(ISNUMBER(G27), IF(ABS(G27)>= 2%, "X", "●") ,"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks for the help
ChemistB the =IF(ABS(G27)>=2%,"X",IF(ABS(G27)<=1.99%,"●")) worked perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks