Spreadsheet formula

[sdc83]

Hi everyone struggling to make a formula work and would really appreciate some help. Below is what I need to do.

If cell A3 = “load” I need cell I3 to perform sum (I2+F3)
If cell A3 = “discharge” I need cell I3 to perform sum (I2-H3)
If cell A3 = “Clean” in need cell I3 to show Clean

I’m having trouble making all three work together in the same cell.

 

[Sufiyan97]

Hi everyone struggling to make a formula work and would really appreciate some help. Below is what I need to do.

If cell A3 = “load” I need cell I3 to perform sum (I2+F3)
If cell A3 = “discharge” I need cell I3 to perform sum (I2-H3)
If cell A3 = “Clean” in need cell I3 to show Clean

I’m having trouble making all three work together in the same cell.

Try

Book1
	A	B	C	D	E	F	G	H	I
1
2									1
3	clean					2		1	Clean
4
5
Sheet1

Cell Formulas
Range	Formula
I3	I3	=IF(A3="Load",I2+F3,IF(A3="Discharge",I2-H3,IF(A3="Clean","Clean","")))

 

[KevCarter]

Untested

Please try:

= IFS(A3="","", A3 = “load” , I2+F3 , A3 = “discharge” , I2-H3 , A3 = “Clean” , "Clean")

 

[Fluff]

How about

=IF(A3="Clean",A3,IF(A3="load",I2+F3,IF(A3="discharge",I2-H3,"??")))

 

[Sufiyan97]

sdc83​

Ignore my formula and use Fluff's formula​

 

[kvsrinivasamurthy]

Try this

=IF(A3="load",I2+F3,IF(A3="discharge",I2+H3,IF(A3="Clean","","")))

 

[sdc83]

Perfect, thanks for the help everyone

 

[Fluff]

Glad we could help & thanks for the feedback.