close

I am trying to set up an If, Then statement in which I reference a cell. The
cell value can be a negative or positive number.

For example:

Column A is a number 1-999
Column B is a positive or negative or blank
Column C is a percentage if column B is negative only

Can anyone help set this formula up?

Thanks


spreadsheets.about.com/cs/exc...iffunction.htm

This site has pretty good explaination for the if, then statement. It
gets into nested statements and things like that as well. It helped
when I needed a little help in this same area.

--
agrimes75
------------------------------------------------------------------------
agrimes75's Profile: www.excelforum.com/member.php...oamp;userid=30790
View this thread: www.excelforum.com/showthread...hreadid=504459

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()