IF statement help-Calculate a Cell

"RudeYute" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> What im trying to do is,
> Calculate a Cell x say 0.5. If the result is a negative number, show
> 0. If it is a positive number, work it out and show the answer. Just
> tried, and cant seem to get it right for some reason. I dont want to
> have to use another cell for no reaon, as I need to present the
> worksheet.
>
> This is what I tried, IF((E22*0.5)>0), (E22*0.5), 0
>
> Thanks
>
>
> --
> RudeYute
> ------------------------------------------------------------------------
> RudeYute's Profile:
> http://www.excelforum.com/member.php...o&userid=32959
> View this thread: http://www.excelforum.com/showthread...hreadid=527847


So close...

=IF(E22*.5>0,E22*.5,0)

Beege

=MAX(E22*0.5,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"RudeYute" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> What im trying to do is,
> Calculate a Cell x say 0.5. If the result is a negative number, show
> 0. If it is a positive number, work it out and show the answer. Just
> tried, and cant seem to get it right for some reason. I dont want to
> have to use another cell for no reaon, as I need to present the
> worksheet.
>
> This is what I tried, IF((E22*0.5)>0), (E22*0.5), 0
>
> Thanks
>
>
> --
> RudeYute
> ------------------------------------------------------------------------
> RudeYute's Profile:
http://www.excelforum.com/member.php...o&userid=32959
> View this thread: http://www.excelforum.com/showthread...hreadid=527847
>

Originally Posted by Beege

"RudeYute" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> What im trying to do is,
> Calculate a Cell x say 0.5. If the result is a negative number, show
> 0. If it is a positive number, work it out and show the answer. Just
> tried, and cant seem to get it right for some reason. I dont want to
> have to use another cell for no reaon, as I need to present the
> worksheet.
>
> This is what I tried, IF((E22*0.5)>0), (E22*0.5), 0
>
> Thanks
>
>
> --
> RudeYute
> ------------------------------------------------------------------------
> RudeYute's Profile:
> http://www.excelforum.com/member.php...o&userid=32959
> View this thread: http://www.excelforum.com/showthread...hreadid=527847


So close...

=IF(E22*.5>0,E22*.5,0)

Beege

Perfect, thanks!