IF then statement question
Hi,
I have four cells of data (A1 through D1). I have created an If then statement where If A1 is less than 500, D1 = B1. I also want to have it so that If A1 500 then D1=C1. How would I write a formula for this. Can anyone help? Thanks -- Chuck W |
IF then statement question
Try something like:
=IF(A1<500,B1,C1) or =IF(A1<500,B1,IF(A1500,D1,0)) if A1 = 500 then this formula will return 0, adjust to suit! HTH Jean-Guy "ChuckW" wrote: Hi, I have four cells of data (A1 through D1). I have created an If then statement where If A1 is less than 500, D1 = B1. I also want to have it so that If A1 500 then D1=C1. How would I write a formula for this. Can anyone help? Thanks -- Chuck W |
IF then statement question
Use two IFs, one to check if A1<500 and the other to check if A1500. Type in
cell D1: =IF(A1<500, B1, IF(A1500, C1, "A1=500")) Note that if A1 = 500 the formula will show "A1=500" because you didn't tell what to do if A1=500. If you say that if A1 is less than or equal to 500, D1=B1 then the formula is simpler: =IF(A1<=500, B1, C1) -- Rogerio Takejame Americana - Sao Paulo - Brazil "ChuckW" wrote: Hi, I have four cells of data (A1 through D1). I have created an If then statement where If A1 is less than 500, D1 = B1. I also want to have it so that If A1 500 then D1=C1. How would I write a formula for this. Can anyone help? Thanks -- Chuck W |
All times are GMT +1. The time now is 04:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com