How would this be written in PHP
=IF((VLOOKUP(B4,PNTVAL,2,FALSE))+C4+F4>0,(VLOOKUP(B4,PNTVAL,2,FALSE))+C4+IF(D4>0,VLOOKUP(D4,qualPntval,2,FALSE),0)+IF(E4>0,VLOOKUP(E4,qualPntval,2,FALSE),0)+F4,"")
It is going to be very similar.
if's are very much alike
if (isset($var)) { //do something }
The cells ids would be much like variables. So B4 could be $B4
And as far as math goes they both work identically
Unfortunately for a much more detailed explanation, some of the functions you have in that will need a bit of explanation as to what they do. "VLOOKUP" "PNTVAL" and "qual". Unless someone here is a bit more experienced with Excel and already knows what they do.
VLOOKUP(a,b,c,FALSE) means
This ia vertical search from another sheet/ tables :
a - a value what you select
b - you add an area, for example a column to a column: A:Z
c - this is that index what the function gives you back from the first result's rows
In your case, PNTVAL need to be an area in your case!
So basically vlookup looks like a function which gives you the field using a parameter from a table.
