wrong syntax
Im trying to do something like this but i havent gotten the right syntax
if c:4 is 300 and <400 subtract 43 and multiply by .36 |
Hi
2 possible solutions - the first one returns an empty string (or any other result on your choice), when conditions aren't filled, the other returns 0 in this case: =IF(AND(C4300,C4<400),(C4-43)*0.36,"") =AND(C4300,C4<400)*(C4-43)*0.36 Arvi Laanemets "Asta" wrote in message ... Im trying to do something like this but i havent gotten the right syntax if c:4 is 300 and <400 subtract 43 and multiply by .36 |
All times are GMT +1. The time now is 12:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com