Arvi has given you one solution, but if you post your conditions and there
is a logical pattern to them then someone will often come up with something
a lot smaller and far more scalable.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Asta" wrote in message
...
I have created this: =IF(AND(C4300,C4<400),(C4-43)*0.36,"")
but i'd like to add more in the greater,Smaller than category and on each
add different subtractions and multiplication. How would i do such a
thing?
|