=
I want to have a cell = a value based on anothers cells input
ex. =IF(P3=Q2and<=Q3,M3,R3) I can get it to work with =IF(P3=Q2,M3,R3) however I need the secound part of the range Thanks Dan |
One way:
=IF(AND(P3=Q2,P3<=Q3),M3,R3) In article , Dan wrote: I want to have a cell = a value based on anothers cells input ex. =IF(P3=Q2and<=Q3,M3,R3) I can get it to work with =IF(P3=Q2,M3,R3) however I need the secound part of the range Thanks Dan |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com