IF STATEMENTS

[DAN D]

Hi
I am making a spreadsheet that should figure out the average numbers of days that it takes an insurance policy to issue
I have 3 total columns. The first two are "day sold" and "day issued." the third is the "total numbers of days". The problem that I am having is when you put in the data in "day sold" it is going to be a couple of days before you put in the data for "Day issued". Until that time it is giving me a negative number and I need to figure out how to keep that number zero until both pieces of data are entered.

Can someone help please?

 

[Kent]

A1 is date sold
B1 is date issued
C1 is =IF((B1-A1)<0,"0",B1-A1)

If you want C1 to be blank until issued, instead of "0"
use "". Or perhaps you'd like
=IF((B1-A1)<0,"Pending",B1-A1)

Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
-----------
Every member of the CanHelpYou team holds at least a
Microsoft Level 1 Excel certification. In addition, we
have experts in PowerPoint, Word and other products such
as IIS, SQL Server 2000, network connectivity.

-----Original Message-----
Hi,
I am making a spreadsheet that should figure out the

average numbers of days that it takes an insurance policy
to issue.

I have 3 total columns. The first two are "day sold"

and "day issued." the third is the "total numbers of
days". The problem that I am having is when you put in
the data in "day sold" it is going to be a couple of days
before you put in the data for "Day issued". Until that
time it is giving me a negative number and I need to
figure out how to keep that number zero until both pieces
of data are entered.

 

[Arvi Laanemets]

Hi

=IF(DayIssued="",0,DayIssued-DaySold)
or
=IF(DayIssued="","",DayIssued-DaySold)

(and it'll be a smart move to use data validation for DayIssued column to
restrict accidental entries with DayIssued<DaySold)


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

Hi,
I am making a spreadsheet that should figure out the average numbers of

days that it takes an insurance policy to issue.

I have 3 total columns. The first two are "day sold" and "day issued."

the third is the "total numbers of days". The problem that I am having is
when you put in the data in "day sold" it is going to be a couple of days
before you put in the data for "Day issued". Until that time it is giving
me a negative number and I need to figure out how to keep that number zero
until both pieces of data are entered.

 

[Bob Phillips]

Or

=MAX(0,DaySold - DayIssued)

and don't show zero (Tools>Options>View)

--

HTH

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