Formula needed

Thanks Norman worked BRILLIANTLY
(DU131="","",IF(DU1310,"CREDIT",IF(DU131=0,"",I F(AND(DU132=DL131,DL131"
"),"MORE THAN 60 DAYS OVERDUE--","30 DAY OVERDUE, IGNORE IF PAID--"))))

--



Thanks in advance for your help....Bob Vance
"Norman Harker" wrote in message
...
Hi Bob!

This looks like it:

=IF(B2="","",IF(B20,"CREDIT",IF(B2=0,"",IF(AND(B1 =B3,B3""),"Overdue
more than 1 month","Overdue 1 month"))))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Hi Bob!

We got there in the end!

You might note the process of how we built it up in stages, checking
each stage as we went.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Your the Geniuses im just the layman but happy that someone was there to
give me a hand ))

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

"Norman Harker" wrote in message
...
Hi Bob!

We got there in the end!

You might note the process of how we built it up in stages, checking
each stage as we went.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Try,

=IF(D4=25,D4*5.25%,1.31+(D4*2.75%))

If it's currency, you might want to round it to 2 dec pl.

=ROUND(IF(D4=25,D4*5.25%,1.31+(D4*2.75%)),2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tmallow" wrote in message
...
Im trying to find a formula that will calculate my fees.... D4 is the
number im using.... if it is $25 or less = 5.25%, if it is $25.01 or more =
$1.31 plus 2.75%
anyone have any ideas on this one?

=IF(D4=25,D4*0.0525,D4*0.0275+1.31)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"tmallow" wrote in message
...
Im trying to find a formula that will calculate my fees.... D4 is the number
im using.... if it is $25 or less = 5.25%, if it is $25.01 or more = $1.31 plus
2.75%
anyone have any ideas on this one?


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.562 / Virus Database: 354 - Release Date: 16/01/2004