Thread
:
Help with formula
View Single Post
#
9
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Help with formula
Does:
=IF(K11<=MAX(TODAY(),O11),N11,R11)*H11
Do what you want?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Geestar" wrote in message
...
I work for a small homeless charity in Kent, UK, and I am setting up a way
of recording our housing benefit payments made to us.
Basically, What I would like to do is have a formula in box T11 that
displays the following:
If the date in K11 is before or the same as todays date in O11 then the
figure in T11 should be the sum of N11 multiplied by H11.
If the date in K11 is blank or after todays date in O11 then the figure in
T11 should be the sum of R11 x H11.
At present I have the following formula in T11
=IF(K11<=O11,SUM(N11*H11),IF(K11O11,SUM(R11*H11)) ) however if cell K11 is
empty it does not calculate propery!
Some advice would be greatly appreciated!
Many Thanks
Regards
Gareth
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann