If function?

[AyyJayEll]

Please help- I am trying to use the if function for the following- I run reports that return a dollar value which can be either positive or negative. In a separate cell I’m trying to get it to. Look at the cell if it is a negative amount paste it either word profit. If it is positive paste with the word loss. - my attempt- =if(a1>0,”a1 Loss”,”a1 Profit”).

 

[snjpverma]

try this

=IF(A1>0,"a1 Loss","a1 Profit")

 

[philwojo]

I think you need to make it a1<0 or flip your "a1 loss"/"a1 Profit" labels around, either should work.

 

[AyyJayEll]

Either way returns the same thing. Instead of cell value and either profit/loss it returns cell number profit/loss

 

[Joe4]

Anything enclosed in double-quotes is treated as literal text. So cell references need to be outside of the double-quotes and concatenated together with your literal text, i.e.

[COLOR=#333333]=if(a1>0,a1 & " Loss",a1 & " Profit")[/COLOR]

or

[COLOR=#333333]=a1 & if(a1>0," Loss"," Profit")[/COLOR]

 

[jtakw]

Hi,

I think may be you want this:

Book1
	A	B	C
1	99		99 Profit
2	-15		-15 Loss
Sheet58

Cell Formulas
Range	Formula
C1	=IF(A1>0,A1&" Profit",A1&" Loss")

Switch the logic around if that's what you want (i.e. " Profit", " Loss")

 

[AyyJayEll]

Thanks a million!