Fri 3 Oct, 2003 12:14 am - If J14 has a value of 74 and L14 has a value of 8
In N14 I get 5% of 74 by formula =sum(J14*5%) result should be 4
In O14 I need the amount over 5% so I use formula =sum(L14-N14) result should... (view)
Wed 1 Oct, 2003 07:09 pm - Exel Help - Seasoned Member
Hello Seasoned Member, I sent you an email to your yahoo address with the file.
Thank you. (view)
Wed 1 Oct, 2003 05:59 pm - Excel
what I'm trying to find out is how to write a formula that if multiplied by zero will not give me a negative answer.
I have five columns:
column A1 is total = 81
column A2 is... (view)
Tue 30 Sep, 2003 11:02 pm - I am trying to write a formula in excell.
If I am trying to multiply by 0 but I don't want to receive a negative what would be the correct formula?
Column Titles
A1=Total , B1=OOW %,... (view)
