IF Statements using BUT - is there such a thing

[esulpher]

I am trying to use an IF statement involving two arguments - IF Cell XX is = "blank" then bring back the SUM of Cells XX-XX BUT IF Cell XX [this is the same cell as the first reference] is = "non blank" then bring back the SUM of Cells YY-YY. Is this possible? If so how would I do this?

Thank you

[Trevor Shuttleworth]

Well, cell XX is either blank or it's not, so:

=IF(XX="",SUM(YY:YY),SUM(ZZ:ZZ))

Regards

Trevor


"esulpher" <[email protected]> wrote in
message news:[email protected]...
>
> I am trying to use an IF statement involving two arguments - IF Cell XX
> is = "blank" then bring back the SUM of Cells XX-XX BUT IF Cell XX
> [this is the same cell as the first reference] is = "non blank" then
> bring back the SUM of Cells YY-YY. Is this possible? If so how would
> I do this?
>
> Thank you
>
>
> --
> esulpher
> ------------------------------------------------------------------------
> esulpher's Profile:
> http://www.excelforum.com/member.php...o&userid=36606
> View this thread: http://www.excelforum.com/showthread...hreadid=563477
>

[CarlosAntenna]

Cell XX can only assume two values, "blank" or "non blank" therefore you
only need to test for one condition.

=IF(XX="",SUM(XX:XX),SUM(YY:YY))

--
Carlos

"esulpher" <[email protected]> wrote in
message news:[email protected]...
>
> I am trying to use an IF statement involving two arguments - IF Cell XX
> is = "blank" then bring back the SUM of Cells XX-XX BUT IF Cell XX
> [this is the same cell as the first reference] is = "non blank" then
> bring back the SUM of Cells YY-YY. Is this possible? If so how would
> I do this?
>
> Thank you
>
>
> --
> esulpher
> ------------------------------------------------------------------------
> esulpher's Profile:
http://www.excelforum.com/member.php...o&userid=36606
> View this thread: http://www.excelforum.com/showthread...hreadid=563477
>

[esulpher]

Thank you Trevor and Carlos. That does make sense....I've been at this worksheet for days and I'm starting to redo what I've already redone...yikes!

Cheers...E