Jun 02 2022 08:33 PM
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
Jun 02 2022 10:36 PM - edited Jun 02 2022 11:55 PM
@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.