Printing pcs (pieces) pc (piece)

[rapitorres]

HI EVERYONE IM NEW HERE IN MREXCEL.

I'M WONDERING IS IT POSSIBLE TO PRINT PC AND PCS
IN EXCEL 2010.

I've tried using if function

in cell B1
=if(A1<=1,"PC","PCS")
successfully

when I type 1 in cell A1 I got "PC"
when I type 2 or up I got "PCS"

my problem is if i type nothing it showed
"PC" still. now i want that if i type nothing as in blank i should get a blank cell.

hope you understand and help me. thanks alot!

 

[FormR]

Hi, welcome to the board.

You could try:

=IF(A1="","",IF(A1>1,"PCS","PC"))

 

[rapitorres]

wow! your amazing! it Worked! thanks alot! looking forward for more