If function help

[krisso]

I am not sure if this is possible or not but I am trying to write an if condition for a sum on a spreadsheet that if it doesn't meet the criteria that it doesn't calculate and leaves the previous value

This is my if statement =IF(A1="final",SUM('Post 9-30am payments'!B1+'Post 9-30am payments'!L1),Previous Value)

Basically this is a daily figures spreadsheet and A1 will have a value of updating until the date is changed to todays date and then the value will change by way of another if statement to Final when the date matches todays date.

Is this possible?

Thanks
Chris

 

[oldbrewer]

say A1 = 100 and you want it to be 200 if B1="RED" but stay at 100 if B1 is not "RED"

this cannot be done with a formula, but is easy with a macro

if cells(1,2) = "RED" then cells(1,1)=200

cells (1,1) [A1] is not amended unless B1 = "RED"

 

[krisso]

I thought it was the case.

I can't use a macro as the sheet is used through excel online

Thanks for the help though