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
P
Q
6
#VALUE!
 Got missing number in column E CSE equivalent CSE equivalent
7
Title 5
Title 6
Title 7
Title 8
Title 9
Title 10
8
 eileenslounge
1000.00
1000
 Got one or more missing numbers
9
1
 eileenslounge1
4.00
4
 Got missing number in column E
10
1
2
 eileenslounge2
9.00
9
11
2
3
 Others
16.00
16
12
3
4
 eileenslounge
1000.00
1000
13
4
5
 eileenslounge1
36.00
36
14
5
6
 eileenslounge2
49.00
49
15
6
7
 Others
64.00
64
16
7
8
17
8
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
P
Q
6
=IF(G6="eileenslounge",1000,F7*E8)
 =IF(F7="","Got one or more missing numbers",IF(E8="","Got missing number in column E","")) CSE equivalent CSE equivalent
7
Title 5
Title 6
Title 7
Title 8
Title 9
Title 10
8
 eileenslounge
=IF(G8="eileenslounge",1000,F9*E10)
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(F8:F16="","Got one or more missing numbers",IF(E8:E15="","Got missing number in column E",""))
9
1
 eileenslounge1
=IF(G9="eileenslounge",1000,F10*E11)
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(F8:F16="","Got one or more missing numbers",IF(E8:E15="","Got missing number in column E",""))
10
1
2
 eileenslounge2
=IF(G10="eileenslounge",1000,F11*E12)
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(F8:F16="","Got one or more missing numbers",IF(E8:E15="","Got missing number in column E",""))
11
2
3
 Others
=IF(G11="eileenslounge",1000,F12*E13)
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(F8:F16="","Got one or more missing numbers",IF(E8:E15="","Got missing number in column E",""))
12
3
4
 eileenslounge
=IF(G12="eileenslounge",1000,F13*E14)
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(F8:F16="","Got one or more missing numbers",IF(E8:E15="","Got missing number in column E",""))
13
4
5
 eileenslounge1
=IF(G13="eileenslounge",1000,F14*E15)
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(F8:F16="","Got one or more missing numbers",IF(E8:E15="","Got missing number in column E",""))
14
5
6
 eileenslounge2
=IF(G14="eileenslounge",1000,F15*E16)
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(F8:F16="","Got one or more missing numbers",IF(E8:E15="","Got missing number in column E",""))
15
6
7
 Others
=IF(G15="eileenslounge",1000,F16*E17)
=IF(G8:G15="eileenslounge",1000,F9:F16*E10:E17)
 =IF(F8:F16="","Got one or more missing numbers",IF(E8:E15="","Got missing number in column E",""))
16
7
8
17
8
Worksheet: data