Addition needed to formula?

[Bob Vance]

--

=IF(DU161<=0,"","PLEASE IGNOR THIS OVERDUE BALANCE IF PAID-->")
but if DU162 has the same value " OVERDUE BALANCE"
Thanks in advance for your help....Bob Vance

 

[Norman Harker]

Hi Bob!

What do you want to do if DU162 has the same value " OVERDUE BALANCE"

Do you want to change the "" on true or the PLEASE IGNORE..." on
false?
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Vance]

Sorry if DL204 has the same value "OVERDUE ACCOUNT"

 

[Norman Harker]

Hi Bob!

I'm not sure that I do what you want if DL204 has OVERDUE ACCOUNT but
look at the following:

=IF(DU161<=0,"",IF(DL204="OVERDUE ACCOUNT","","PLEASE IGNORE THIS
OVERDUE BALANCE IF PAID-->"))

You should be able to adapt it.

One way of shortening your formulas would be to put your messages into
cells and to refer to them:

So if OVERDUE ACCOUNT was put in DZ1 and PLEASE IGNORE THIS OVERDUE
BALANCE IF PAID--> was put in DZ2:

=IF(DU161<=0,"",IF(DL204=DZ1,"",DZ2))

If you named DZ1 ODAMess and DZ2 NormODMess

=IF(DU161<=0,"",IF(DL204=ODAMess,"",NormODMess))

This makes formulas shorter and easier to understand.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Vance]

What I am trying to do in DT203, is if the cell DU203 has any value above
zero to show " Please ignor this amount...." but if the cell shows no value
"" and if the value is the same as DL204 to show "Account Overdue"

Thanks in advance for your help....Bob Vance

 

[Norman Harker]

Hi Bob!

I think I've got it, but check:
=IF(DU203>0,"Please ignore this amount.>>",IF(DU203=DL204,"Overdue
account",""))

DU203>0 takes precedence in processing over the DU203=DL204 condition.

That appears logical.
If the account is positive "ignore it" in all cases even if the same
as last month.
If the account is negative then "no message" unless it's the same as
last month in which case it's overdue and time for a visit from Al
Pacino.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Vance]

Yes the first condition is working, but not the second condition seems to
get over ridden by the first

 

[Norman Harker]

Hi Bob!

That's the way IF functions work.

If the condition is satisfied the true_statement is evaluated and
that's it.

If this isn't what you want, then you'll need to re-explain your
logic.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Vance]

I want the cell to show "PLEASE IGNORE.........." if DU203 has a value of
more than zero, BUT if DL203 has a value more than zero I want the cell to
read "ACCOUNT OVERDUE" and if both no value " " Blank
So maybe doing it in reverse if DL203 >0 "ACCOUNT OVERDUE" if not then if
DL203>0 "PLEASE IGNORE...." if both no value " "Blank

 

[Norman Harker]

Hi Bob!

Try again!

=IF(DL203>0,"Account Overdue",IF(DU203>0,"Please ignore..",""))

But I've assumed a typo in your revision. Last reference to DL203
should be DU203

We'll get there if it kills us.

With two cells with values in them, you have 9 options:

DL<0 DU <0 or 0 or >0 (3 options)
DL=0 DU <0 or 0 or >0 (3 options)
DL>0 DU <0 or 0 or >0 (3 options)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.