Untitled.jpg
I AM TRYING TO ADD A MAXIMUM VALUE OF £8000 POUNDS TO THIS CELL WHISLT USING THIS FORMULA =SUM(E7>2000,E7-2001) . i ALSO WANT THE REMAINDER TO BE CARRIED OVER TO CELL E15. I WOULD REALLY APPRECIATE SOMEONES HELP ASAP!
THANKS
Untitled.jpg
I AM TRYING TO ADD A MAXIMUM VALUE OF £8000 POUNDS TO THIS CELL WHISLT USING THIS FORMULA =SUM(E7>2000,E7-2001) . i ALSO WANT THE REMAINDER TO BE CARRIED OVER TO CELL E15. I WOULD REALLY APPRECIATE SOMEONES HELP ASAP!
THANKS
Last edited by romperstomper; 12-09-2011 at 11:54 AM.
Hi and welcome to the board.
Please attach your sheet instead of a picture and remember that writing in uppercase is the equivalent of shouting ( which is not necessary, I gather?)
Book1.xls
Thank you for your imput. You are right about the shouting :D Not intended. Sorry. I have attached the sheet as asked. Thankyou
I would do it as in the attached version of your file.
Remember what the dormouse said
Feed your head
Makes perfect sense! GENIUS!
Thankyou very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks