IF STATEMENTS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Click to expand...
average numbers of days that it takes an insurance policy
to issue.
I have 3 total columns. The first two are "day sold"
Click to expand...
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.
 
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


DAN D said:
Hi,
I am making a spreadsheet that should figure out the average numbers of
Click to expand...
days that it takes an insurance policy to issue.
I have 3 total columns. The first two are "day sold" and "day issued."
Click to expand...
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.
 
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)
 
Back
Top