Hi,

I am trying to devise a form that will calculate travel expenses. Users
will input their mileometer readings (the start and end readings) in L4
and N4 respectively.In cell G4 users will input their reason for
travel, either 'Travel between sites' or another reason.

If the string in G4 is 'Travel between sites' then the formula (N4-L4)
should return the result in P4 (entitled Business Miles). If the string
in G4 is anything else the result should be returned in T4 (Home to
base). I do not want 0 values for blank values in L4 and N4 to show on
the form so I have got:

=IF(ISBLANK(N4),"",N4-L4)

Can anyone suggest a way of achieving both goals, ie keeping blank
cells empty AND checking the string in G4 to return a value (N4-L4) in
either P4 or T4?

Any suggestions gladly received :)


--
Marie1uk
------------------------------------------------------------------------
Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984
View this thread: http://www.excelforum.com/showthread...hreadid=546141