adding a new command- copying a text from another cell

Contributor

Hey all,

Just trying to work out how to make a cell display the word "DEPOSIT" if another cell in the same row has DEPOSIT written in it. It will need to fit in the following command.. =IF(ISBLANK(D14),"",IF(ISBLANK(O14),"OPEN",IF(P14>0,"W","L"))) Thanks heaps

1 Reply

@Ding080 How about something like this:

=IF(ISBLANK(D14),"",IF(ISBLANK(O14),"OPEN",IF(E14="DEPOSIT","DEPOSIT",IF(P14>0,"W","L"))))

This is a working formula but I can't tell if it will do what you want. With nested IF functions it's important that you put each of them in the correct order.