If + Offset

[arifanmol]

can i be suggested to modify correctly my excel formula combining if and offset displays the output FALSE in stead of expected output ?

 

[Marcilio]

arifanmol, Good morning.

Try to put in A4 --> =IF(D7=4, OFFSET(D6,-1,0), "Nothing")

The "FALSE" is appearing because what to do is missing in the second argument of the IF function.
I put the word Nothing to fill in the missing argument.

Please, tell us if it is what you need.

have a nice day!

 

[arifanmol]

thanks for above solution
if i want to combine if and search as shown in attached file
plz check and give formula

 

[Marcilio]

arifanmol, good morning.

Try this formula to meet your new exact request.

=IF(COUNTIF(A1:A2,"H"), "accepted", "rejected")

------------------------------------------------------------------------------------------------------------------------
Please do not use the same post to ask for solutions to different questions.

Each question has to have its own post.
This makes it easy for all users to find the solutions that different users kindly provide to requesters.
------------------------------------------------------------------------------------------------------------------------

Have a nice day!

 

[bosco_yip]

thanks for above solution
if i want to combine if and search as shown in attached file
plz check and give formula

Hi @arifanmol

Please stick on "One post one question"

Please open a new thread for your new question.

This thread is closed.