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
Are you a robot you dont seem to comprehending this very well and your answer seems automated.
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
thank you Pike. this is the first time I had this problem for the past about six or seven years.l
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
Don’t have an account yet? Register yourself now and be a part of our community!