Ask Your Question
0

The parts of my if formula work separately but not together. Err:509

asked 2018-09-21 00:13:50 +0200

Zedicus Azul gravatar image

updated 2018-09-21 00:25:14 +0200

This is supposed to check column F for text, than return AA/BB/CC if blank or AA:BB:CC (A or P)M otherwise. All the parts work. The final formula does not. What am I doing wrong?

This is from sheet 10 of a book. The tested formulas show results from row 2 and 3. Columns A, B, and C have a 2 digit number. D has a alphanumeric. E is empty. F has AM, PM, or nothing. G has test formulas.

A B C D E F G

Hour Minute Second Temp Time Temporary

03 35 32 47C Err:509 Does not work

11 11 06 73U AM Err:509

10 16 27 38V PM '=IF(F2="",A2 & "/" & B2 & "/" & C2, Sheet10.A2 & ":" & Sheet10.B2 & ":" & Sheet10.C2 & " " F2)

12 22 59 47Ff
07 12 31 58If AM
09 18 54 74W AM
05 16 24 36L PM
04 21 00 37X 3/35/32 Works

04 04 21 54O AM 11/11/6

06 10 53 34Df AM '=A2 & "/" & B2 & "/" & C2

01 15 22 72Yf PM 3:35:32 Works

03 58 48 72R PM 11:11:6 AM

11 56 20 68Zf PM '=Sheet10.A2 & ":" & Sheet10.B2 & ":" & Sheet10.C2 & " " & F2

01 24 54 37A
03 22 15 22Bf AM
11 05 52 76U AM
11 03 16 67Cf PM A Works

06 01 42 62D B

05 52 17 62Ef AM '=IF(F2="","A","B")

Edit

*3/35/32 *Works

11:11:6 AM

'=IF(F2="",G9,G12)**

edit retag flag offensive close merge delete

Comments

please provide a sample file (put it to a network share, and edit your question to add link to it). It's error-prone to try to reproduce all that.

Mike Kaganski gravatar imageMike Kaganski ( 2018-09-21 00:29:15 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-09-21 00:41:48 +0200

updated 2018-09-21 08:21:52 +0200

Err509 is a “Missing operator error”. You have missed & sign before the last F2 reference. The ending should look like Sheet10.C2 & " " & F2)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-21 00:13:50 +0200

Seen: 52 times

Last updated: Sep 21 '18