I am trying to substract Column F value from column B.

giving me incorrect output. =F2--B2

When tried =D2--A2 gives me Correct output.

looking your help in excel formula or vba both ok. thanks

Below is a snapshot Column G gives wrong output, expected output shown in H2:H3.

Book7 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | H | |||

1 | Outstanding Balance | Bal as per SAP | Sum Amt | Difference | Today's Balance | Difference | ||||

2 | 5,317.59 | 307.26 | -5317.59 | - | 307.26 | 614.52 | Expected - 0 value in G2 | |||

3 | 5,000.00 | 4,000.00 | -5000 | - | 5,000.00 | 9,000.00 | Expected - 1000 in G3 | |||

4 | ||||||||||

5 | =D2--A2 | =F2--B2 | ||||||||

Sheet1 |

Cell Formulas | ||
---|---|---|

Range | Formula | |

E2:E3 | E2 | =D2--A2 |

G2:G3 | G2 | =F2--B2 |

Thanks

mg