Welcome to WebmasterWorld Guest from 34.238.192.150

Forum Moderators: open

Message Too Old, No Replies

Excel Formula Help

Date & Multiple Formulas In One Cell

     
12:30 am on Jun 7, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 7, 2005
posts:790
votes: 0


I have to admit, I'm rubbish with excel and was hoping an excel guru might be able to help me out with this formula.

I'm trying to set a multiplier for when a certain number of days have passed with the last part of the formula being the most important.


=IF(TODAY()>=S18+61,(R18*10),"")*OR(IF(TODAY()>=S18+46,(R18*5),"")*OR(IF(TODAY()>=S18+31,(R18*2.5),"")))

s18 has the date in it and r18 is my multiplier.

I can get them working individually but it's combining them where I have my problem.

=IF(TODAY()>=S18+61,(R18*10),"")

Can anyone help me out with this one?

Any help is appreciated.