If Function problem

  • Alright soi im trying to make an if function that will check two columns and change a price depending on what in that column and id like it to function for both cloumns.


    What i tried was =if(k6="EUR",j6*V28,j6,if(h6="EUR",g6*v28,g6)) v28 is the exchange rate and columns J and G are prices and H and K are currency labels. Im not familiar with &'s / ors but i think that might help because the one i made isnt working.


    Please help!

  • Re: If Function problem


    "=if(k6="EUR",j6*V28,j6,if(h6="EUR",g6*v28,g6)) "


    write down the logice in prose


    if k6="EUR that cell is equal to J6*v28
    if not that cell is J6
    the if condition is complete and over
    what do you want to say.
    think again and resolve

  • Re: If Function problem


    Ok so i got something to work and am using two formulas for the separate columns H/K and J/G but if there is someway to consoloidate these rfunction into one that works that would be awesome to know.


    =IF(K6="JPY",J6*$V$30,IF(K6="eur",J6*$V$28,IF(K6="mxn",J6*$V$29,IF(K6="CDN",J6*$V$27,"Correct"))))
    and
    =IF(H6="JPY",G6*$V$30,IF(H6="eur",G6*$V$28,IF(H6="mxn",G6*$V$29,IF(H6="CDN",G6*$V$27,"correct"))))

  • Re: If Function problem


    ok let us rephrase it
    if k6="eur" AND H6="eur" then what? is it
    if not what is it


    again is it AND or OR.


    are they two different formulas.


    rephrase in words instead of formlas and then you yourself will get a solution.

  • Re: If Function problem


    ADMINISTRATOR


    see the replly from
    Zpichette Zpichette is offline
    Member
    Join Date
    13th June 2013
    Posts
    53
    Re: If Function problem
    Are you a robot you dont seem to comprehending this very well and your answer seems automated.
    unquote
    Is it necessary to be offensisve to those who try to help that to for free oharges

  • Re: If Function problem


    Zpichette
    Ozgrid forums isa place where everyone can gather to post questions , help others and connect with like-minded people in a safe and welcoming environment. In order to make that happen everyone adheres to certain guidlines.
    Everyone is entitled to their opinion, but no one is entitled to attack others for helping, or not helping. If you can't communicate without using combative, aggressive, or demeaning language, then please keep those comments to yourself.
    venkat1926 is an experinced hand and exceller here to help in his own time!

  • Re: If Function problem


    Zpichette
    the problem with combine the two fucnction is that the logic conflicts
    it is a robot logic and combining your two statements
    =IF(K6="JPY",J6*$V$30........
    and
    =IF(H6="JPY",G6*$V$30.....


    does not work because when K6="JPY" and H6="JPY"the answer cannot be both J6*$V$30 and G6*$V$30


    so which one will take precedent

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!