ExcelBanter - IF Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Formula (https://www.excelbanter.com/excel-discussion-misc-queries/181215-if-formula.html)

Tufail

IF Formula

Hello,
How can I creat following formula in cell A1 ?
If B1 is <0 then in A1 A
If B1 is 0 then in A1 B
If B1 is =0 then in A1 C

Thanks in advance

Gary''s Student

IF Formula

=IF(B1=0,"C",IF(B1<0,"A","B"))

--
Gary''s Student - gsnu200775

Tufail

IF Formula

Thank you very much !

"Gary''s Student" wrote:

=IF(B1=0,"C",IF(B1<0,"A","B"))

--
Gary''s Student - gsnu200775

All times are GMT +1. The time now is 08:54 PM.