wrong syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(C4>300,C4<400),(C4-43)*0.36,"")
=AND(C4>300,C4<400)*(C4-43)*0.36


Arvi Laanemets
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Wrong syntax 2
how to get values in between data? 5
Running Balance in the same cell... 2
Balances 6
hiding zero for a sum 3
Calculate sum of values based on a ref value, how? 4
match 3

Back
Top