I want to write this as a formula: 1 minus F6 divided by F6 plus Z6 plus AA6, but only if AA6 is less than zero
I want to write this as a formula: 1 minus F6 divided by F6 plus Z6 plus AA6, but only if AA6 is less than zero
=if(aa6<0,(1-f6)/(f6+aa6),0)
This will return 0 if aa6 is not less than 0. Replace the 0 with whatever
you want if aa6 is not less than 0.
Shaun
"changetires" wrote:
>
> I want to write this as a formula: 1 minus F6 divided by F6 plus Z6 plus
> AA6, but only if AA6 is less than zero
>
>
> --
> changetires
> ------------------------------------------------------------------------
> changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
> View this thread: http://www.excelforum.com/showthread...hreadid=556093
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks