In Support of this forum question
https://eileenslounge.com/viewtopic....268481#p268481

_____ Workbook: Converting formulas to valuesC.xlsm ( Using Excel 2007 32 bit )
Row\Col
E
F
G
H
I
J
K
L
M
N
O
5
 CSE equivalent CSE equivalent
6
=IF(G6="eileenslounge",1000,F7*E8)
 =IF(E7="","Got one or more missing numbers",IF(F8="","Got missing number in column F",""))
7
Title 5
Title 6
Title 7
Title 8
Title 9
Title 10
8
 eileenslounge
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(E8:E16="","Got one or more missing numbers",IF(F8:F15="","Got missing number in column E",""))
9
1
 eileenslounge1
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(E8:E16="","Got one or more missing numbers",IF(F8:F15="","Got missing number in column E",""))
10
1
2
 eileenslounge2
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(E8:E16="","Got one or more missing numbers",IF(F8:F15="","Got missing number in column E",""))
11
2
3
 Others
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(E8:E16="","Got one or more missing numbers",IF(F8:F15="","Got missing number in column E",""))
12
3
4
 eileenslounge
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(E8:E16="","Got one or more missing numbers",IF(F8:F15="","Got missing number in column E",""))
13
4
5
 eileenslounge1
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(E8:E16="","Got one or more missing numbers",IF(F8:F15="","Got missing number in column E",""))
14
5
6
 eileenslounge2
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(E8:E16="","Got one or more missing numbers",IF(F8:F15="","Got missing number in column E",""))
15
6
7
 Others
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(E8:E16="","Got one or more missing numbers",IF(F8:F15="","Got missing number in column E",""))
16
7
8
17
8
18
Worksheet: data


_____ Workbook: Converting formulas to valuesC.xlsm ( Using Excel 2007 32 bit )
Row\Col
E
F
G
H
I
J
K
L
M
N
O
5
 CSE equivalent CSE equivalent
6
#VALUE!
 Got missing number in column F
7
Title 5
Title 6
Title 7
Title 8
Title 9
Title 10
8
 eileenslounge
1000
 Got one or more missing numbers
9
1
 eileenslounge1
4
 Got one or more missing numbers
10
1
2
 eileenslounge2
9
11
2
3
 Others
16
12
3
4
 eileenslounge
1000
13
4
5
 eileenslounge1
36
14
5
6
 eileenslounge2
49
15
6
7
 Others
64
16
7
8
17
8
18
Worksheet: data