If statement help (if it has negative numbers)

[patni]

Hey guys,
I need a help.

I need hep with a IF statement.


conditions are:

If cell D43 is greater than or equal to 1, then i want it to show text "san"
if cell D43 is in negative number and is greater than or equal to -1, then i want it to show text "san"
If cell D43="", then ""

I did this code but its very clearly wrong.

=IF(D43>=1,"san",IF(D43<0,"san",""))

Can anyone please help me out

Thank you

 

[alansidman]

=if(D43<>"","san", "")

 

[patni]

Hey Alansidman,

The code is not working as of now.

I want it to show "san" if D43 is reater than or equal to 1.

[COLOR=#333333]If cell D43 is greater than or equal to 1, then i want it to show text "san"[/COLOR]
[COLOR=#333333]if cell D43 is in negative number and is greater than or equal to -1, then i want it to show text "san"[/COLOR]
[COLOR=#333333]If cell D43="", then ""[/COLOR]

 

[alansidman]

How can a number be negative and be greater than -1. Are you referring to values between zero and -1 only, ie. -.5 or -.25 for example?

I am reading your request that you want "san" to appear if the value is anything other than blank. What am I missing here.

 

[patni]

Hey Alan.

Really sorry . I forgot basic maths.

I mean -1 and values more than -1 which is -1,-2,-3......

Sorry

 

[FormR]

Hi, here is one option.

=IF(ABS(D43)>=1,"san","")

 

[steve the fish]

ABS will convert a negative number to a positive so could go:

=IF(ABS(D43)>=1,"san","")

presuming that if the number isnt greater than 1 you want a blank.

 

[patni]

Hey Steve,

thank you so much!
It is working perfectly.
Thank you for your time and help.

Thank you! I will update you if i face any problem.
Thanks again

 

[patni]

Hey FormR,

Thank you so much for the help. Its working perfectly!
Thanks for the time

 

[patni]

Hey Alan,
The problem is solved now.
Thank you for the help and your valuable time