2 if functions together

[billykiller05]

How can I use 2 if functions together. My function is
=IF($U9<1,ROUND(AK9-(AK9*$U9),-2),ROUND(AK9-$U9,-2)) and if U9 is
greater than 1 and some of my cells in the range are 0 it gives me a
negative number. How can I add another if function to change the
negative numbers to zero?

 

[Peo Sjoblom]

One possible way

=MAX(IF($U9<1,ROUND(AK9-(AK9*$U9),-2),ROUND(AK9-$U9,-2)),0)

meaning that if the IF function returns less than zero the result will be
zero

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com




"billykiller05" <[email protected]>
wrote in message
news:[email protected]...