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
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
"Asta" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks