Excel smart calculation

[alliswell]

I want is, if A1 and b1 has value then C1 must get value by multiplying A1 and b1 and after clearing A1:C1, if A1 and C1 has value then then b1 must get value by dividing A1 by C1 and after clearing A1: C1, if B1 and C1 has value then A1 must get value By dividing B1 by C1.

If formula can do it it's better or else macro. Thanks every body.

 

[Peter_SSs]

If formula can do it it's better or else macro.

You cannot do that with formulas.

You can try this Worksheet_Change event code. To implement ..
1. Right click the sheet name tab and choose "View Code".
2. Copy and Paste the code below into the main right hand pane that opens at step 1.
3. Test

Private Sub Worksheet_Change(ByVal Target As Range)
  Dim rng As Range, rNums As Range
  Dim c As Long

  Set rng = Range("A1:C1")
  If Not Intersect(Target, rng) Is Nothing Then
    On Error Resume Next
    Set rNums = rng.SpecialCells(xlConstants, xlNumbers)
    On Error GoTo 0
    If Not rNums Is Nothing Then
      If rNums.Count = 2 Then
        Application.EnableEvents = False
        c = IIf(rNums.Areas.Count = 1, (2 * rNums.Column + 1) Mod 4, 2)
        If c = 3 Then
          rng.Cells(c).Value = rng.Cells(1).Value * rng.Cells(2).Value
        Else
          rng.Cells(c).Value = rng.Cells(3).Value / rng.Cells(3 - c).Value
        End If
        Application.EnableEvents = True
      End If
    End If
  End If
End Sub