Forum Discussion

Bhall505's avatar
Bhall505
Copper Contributor
Feb 13, 2023

It's been a while since I had to do calculations so this one should be pretty easy.

=IF(C28<V19, V29, V28   is what is on the spread sheet.  I have taken over this position and I know it is not complete.

 

 

 

C28<V19 should take the value in V28

C28>V29 should take the value in V29

 

I don't know what the formula should be.

 

Thanks for your help. 🙂

Formulas and Functions

5 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 13, 2023

    Bhall505 

    The formula is missing a closing parenthesis:

     

    =IF(C28<V19, V29, V28)

     

    But if the formula should return the value of V29 if C28>V19, it should be

     

    =IF(C28<V19, V28, V29)

    • Bhall505's avatar
      Bhall505
      Copper Contributor
      Mar 07, 2023

      HansVogelaar 

      =IF(C28<V19,V29,V28)

      C28 = 8000.00
      V19 sales price = 5,000.00
      V29 interest = 560.00
      V28 interest = 530.00

      Is it taking 560.00 or 530.00?

      Thank you

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Mar 07, 2023

        Bhall505 

        You can easily test that yourself by entering the formula in a cell.

        With your data, =IF(C28<V19,V29,V28) will return 560.

    • Bhall505's avatar
      Bhall505
      Copper Contributor
      Mar 06, 2023

      HansVogelaar If V19 = 5,000.00 and V29 = 4,200.00 and V28 = 3,650.00.  C28 = 10,000.00

       

      which calculation will be the answer?  4,200.00 or 3,3650.00?  I am just making sure this is correct, which I have my concerns.  It's been awhile since I worked with calculations in excel.

       

      THANK YOU SO MUCH.

       

      Barbara

Resources