add if statement to an if statement

[Learning ExL]

Hi all,

i want to add the two following codes together

this one is already in please

Please Login or Register  to view this content.

i want to add this to it as it relates to a check box

Please Login or Register  to view this content.

[Sam Capricci]

is this what you are wanting?...
=IFERROR(IF($F8="paid","",IF(E8="","",(IF((H8-TODAY())>2, "Processing", IF(H8-TODAY()<0,"Late", "Due"))))),"Processing")
the key to it is what takes priority? does the "paid" value in F8 mean that everything else will be irrelevant? if so that is the position for it. The order in IF/THEN statements is important as whatever is solved first the rest becomes irrelevant.

[Learning ExL]

is it easy to then add that to a check box? as this is what i was trying to achieve

https://www.datanumen.com/blogs/3-me...ontents-excel/

[Learning ExL]

i found some code from 10yrs ago which hides the checkbox if there is nothing in E9 but as soon as i put a date into E9 the checkbox show which is what i want woop! woop! however does this mean that i have to type this code 58 times as i have 58 checkboxes?

Please Login or Register  to view this content.

all i need to do is now work out how on earth to add text to a cell if checkbox is checked, i tried to do what the link in my last post suggested but i cant seem to get it to work

[Learning ExL]

is this what you are wanting?...
=IFERROR(IF($F8="paid","",IF(E8="","",(IF((H8-TODAY())>2, "Processing", IF(H8-TODAY()<0,"Late", "Due"))))),"Processing")

did not work i comes up with "Theres to few arguments"

[Pepe Le Mokko]

Sambo's formula works perfectly for me

[Learning ExL]

this is how i got it to work

Please Login or Register  to view this content.

and to make the check box vanish i used the following

Please Login or Register  to view this content.