Greetings all - I would like very much to get some assistance with the following please, if anyone has thoughts on it.
=IF(BB2="","",IF(AND($AR2="x",$AZ2="L",$AV2="C",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="O",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="B",J3>...
Hi all,
Having a bit of difficulty here figuring out where I am going wrong with this one. The table below is for a lighting audit. The inputs are in red and the formula in cells J2:AG4 are for monday only. The data set continues AH and onward for each day of the week.
I want to be able to...
I have a simple spreadsheet with 4 or five columns in.
Column A and B have data validation which the user will drop down
Column A = Team, Individual
Column B = Winner, Runner up, NA
What I am trying to do is in column E have a formula which looks for the results of A and B and inputs data...
Hello
I can find thread explaining how to use wildcard characters with IF using COUNTIF but I am trying to find something that will search multiple columns to say "Y" or "N" if it is contained in either cell.
=IF((OR(A1="dealing", AB1="dealing")), "Y", "N")
The above formula would do this if...
Hi all, im newbie here, i need your help to create a formula on (T30) with condition
<tbody>
IF (Q30)=(H30)OR(Q30)>(H30)AND(S30)=3 OR (S30)>3 then (T30) will be A
IF (Q30)=(H30)OR(Q30)<(H30)AND(S30)=1 OR (S30)<3 then (T30) will be B
IF...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.