I have 4 worksheets in 1 workbook and I'm trying to do a comparison. I'm providing information to a buyer on items they need to take action on. My first statement goes something like this:
=IF('EFA WK1'!H5 <> 'EFA WK2'!G5, "CHECK!", 0) which works fine.
Now I want to add another statement that basically states If 'Comparison'!H2 is less than or greater than 25% put the CHECK. So far I haven't been able to get it to work.
Any help would be great!!!!
=IF('EFA WK1'!H5 <> 'EFA WK2'!G5, "CHECK!", 0) which works fine.
Now I want to add another statement that basically states If 'Comparison'!H2 is less than or greater than 25% put the CHECK. So far I haven't been able to get it to work.
Any help would be great!!!!