IF function vs Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-2268591%22%20slang%3D%22en-US%22%3EIF%20function%20vs%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2268591%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20needing%20one%20workbook%20to%20feed%20into%20another%20workbook%20with%20constant%20information%20-%20I%20wrote%20the%20If%20formula%20Saturday%20then%20lost%20it%20-%20now%20I%20can't%20get%20it%20to%20work%20right%20-%20ex%3A%26nbsp%3B%20%26nbsp%3Bwe%20have%20a%20workbook%20that%20is%20all%20stores%20with%20their%20new%20leases%20-%20I%20need%20that%20to%20feed%20into%20the%20lease%20review%20spreadsheet%20-%20the%20peer%20review%20will%20be%20ever%20changing%20so%20I%20need%20the%20formula%20to%20basically%20state%20if%20B6%20-%20109%20(etc)%20then%20C6%20%3Dpeerreview%20C6%20-%26nbsp%3B%3C%2FP%3E%3CP%3Eetc....%20but%20it%20isn't%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2268591%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am needing one workbook to feed into another workbook with constant information - I wrote the If formula Saturday then lost it - now I can't get it to work right - ex:   we have a workbook that is all stores with their new leases - I need that to feed into the lease review spreadsheet - the peer review will be ever changing so I need the formula to basically state if B6 - 109 (etc) then C6 =peerreview C6 - 

etc.... but it isn't 

2 Replies
Your description is far too vague for anybody (other than maybe a mind-reader) to give you an answer. Is it possible for you to attach a sample of the actual workbooks (so long as there's no confidential info in them)?

@mathetes 

 

I was afraid it was - I cannot post due to confidentiality - let me do a mock one then I will post it