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