T O P I C R E V I E W |
TimSch |
Posted - 01/06/2019 : 06:51:23 AM Origin 2017G (64-bit) SR2; b9.4.2.380
Hello,
I need your help! At the attached image you see three books. I want to do following thing:
I want to use the Data Y of Book1 and say: If the value in this column is >1 then use the value of Column Data Y of Book2 and put this value in column B(Y) of Book3. If the value in B(Y) of Book1 is <1 then put the value 0 in column B(Y) of Book3.
Thank you for your help! |
2 L A T E S T R E P L I E S (Newest First) |
TimSch |
Posted - 01/07/2019 : 03:34:56 AM Hi,
it is working! Thanks a lot!
Best Regards Tim |
AmandaLu |
Posted - 01/07/2019 : 02:09:00 AM Hi,
Please try conditional operator (?:). For example, define such in the “Before Formula Script”
range nB1=[book1]Sheet1!col(2); range nB2 = [book2]Sheet1!col(2);
then enter
nB1>=1 ? nB2 : 0
in the formula edit box.
Thanks, Amanda OriginLab Technical Service
|