help with simple addition formula

[Juco]

The formula below I am using to add 3 cells. I would like it to add M8 in to
the addition only if M7 is blank. How do I adjust my formula to do this?

M7+M13+M14

thanks

[Max]

One way:

=IF(M7="",M8+M13+M14,M7+M13+M14)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Juco <[email protected]> wrote in message
news:[email protected]...
> The formula below I am using to add 3 cells. I would like it to add M8 in
to
> the addition only if M7 is blank. How do I adjust my formula to do this?
>
> M7+M13+M14
>
> thanks
>
>

[Dana DeLouis]

Here's one idea assuming "blank" means there is nothing in the cell.

=M7+M13+M14+IF(ISBLANK(M7),M8,0)

HTH
--
Dana DeLouis
Win XP & Office 2003


"Juco" <[email protected]> wrote in message
news:[email protected]...
> The formula below I am using to add 3 cells. I would like it to add M8 in
> to
> the addition only if M7 is blank. How do I adjust my formula to do this?
>
> M7+M13+M14
>
> thanks
>
>

[Juco]

Not quite working for me, Maybe the bit below will explain better. I need
to add up M13 M14 in M15 then either M7 or M8 M7 is a weekly rental cost
M8 is a total rental cost Some people might just fill in the weekly if
only renting for one week and leave the total blank, hence the reason i want
to pick up either or of M7 and M8. M8 if they have put the total in if not
then M7.
Hope I am not getting confusing now


Weekly rental M7
Total rental M8
Airport transfer req.
Yes or No no
Welcome pack req.
Yes or No no
Transfer cost return M13
Welcome pack M14
Total rental M15

"Dana DeLouis" <[email protected]> wrote in message
news:%[email protected]...
> Here's one idea assuming "blank" means there is nothing in the cell.
>
> =M7+M13+M14+IF(ISBLANK(M7),M8,0)
>
> HTH
> --
> Dana DeLouis
> Win XP & Office 2003
>
>
> "Juco" <[email protected]> wrote in message
> news:[email protected]...
> > The formula below I am using to add 3 cells. I would like it to add M8
in
> > to
> > the addition only if M7 is blank. How do I adjust my formula to do this?
> >
> > M7+M13+M14
> >
> > thanks
> >
> >
>
>

[Dana DeLouis]

Would this idea work? There's no error checking though:

= M13+M14+IF(ISBLANK(M7),M8,M7)

or maybe something like this:
= M13+M14+MAX(M7,M8)

Not sure how to set up some type of error checking for you though.

--
Dana DeLouis
Win XP & Office 2003


"Juco" <[email protected]> wrote in message
news:[email protected]...
> Not quite working for me, Maybe the bit below will explain better. I need
> to add up M13 M14 in M15 then either M7 or M8 M7 is a weekly rental
> cost
> M8 is a total rental cost Some people might just fill in the weekly if
> only renting for one week and leave the total blank, hence the reason i
> want
> to pick up either or of M7 and M8. M8 if they have put the total in if not
> then M7.
> Hope I am not getting confusing now
>
>
> Weekly rental M7
> Total rental M8
> Airport transfer req.
> Yes or No no
> Welcome pack req.
> Yes or No no
> Transfer cost return M13
> Welcome pack M14
> Total rental M15
>
> "Dana DeLouis" <[email protected]> wrote in message
> news:%[email protected]...
>> Here's one idea assuming "blank" means there is nothing in the cell.
>>
>> =M7+M13+M14+IF(ISBLANK(M7),M8,0)
>>
>> HTH
>> --
>> Dana DeLouis
>> Win XP & Office 2003
>>
>>
>> "Juco" <[email protected]> wrote in message
>> news:[email protected]...
>> > The formula below I am using to add 3 cells. I would like it to add M8
> in
>> > to
>> > the addition only if M7 is blank. How do I adjust my formula to do
>> > this?
>> >
>> > M7+M13+M14
>> >
>> > thanks
>> >
>> >
>>
>>
>
>

[Aladin Akyurek]

Juco wrote:
> Not quite working for me, Maybe the bit below will explain better. I need
> to add up M13 M14 in M15 then either M7 or M8 M7 is a weekly rental cost
> M8 is a total rental cost Some people might just fill in the weekly if
> only renting for one week and leave the total blank, hence the reason i want
> to pick up either or of M7 and M8. M8 if they have put the total in if not
> then M7.
> Hope I am not getting confusing now
>
>
> Weekly rental M7
> Total rental M8
> Airport transfer req.
> Yes or No no
> Welcome pack req.
> Yes or No no
> Transfer cost return M13
> Welcome pack M14
> Total rental M15
[...]

Perhaps...

=SUM(M13:M15,IF(N(M8),M8,M7))

[Cutter]

How about simply this:

In M15 type: =M13+M14+MAX(M7,M8)

OR same thing but written a different way: =SUM(M13:M14,MAX(M7:M8))